View last 10
Profile for:
GET
http://www.thehubcaps.com/app_dev.php/blog/category/domain-names/
by 18.222.233.22 at Fri, 30 May 2025 20:17:39 +0000
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.72 ms |
SELECT b0_.id AS id_0 FROM blog_post b0_ LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id WHERE b1_.category_slug = ? AND b0_.is_publish = ? ORDER BY b0_.created_on DESC
Parameters: [domain-names, 1]
|
2 | 0.96 ms |
SELECT b0_.id AS id_0, b0_.post_title AS post_title_1, b0_.post_body AS post_body_2, b0_.post_slug AS post_slug_3, b0_.created_on AS created_on_4, b0_.updated_on AS updated_on_5, b0_.is_publish AS is_publish_6, b0_.post_robots AS post_robots_7, b0_.post_meta AS post_meta_8, b0_.views AS views_9, b1_.id AS id_10, b1_.category_name AS category_name_11, b1_.category_slug AS category_slug_12, b1_.post_robots AS post_robots_13, b2_.id AS id_14, b2_.name AS name_15, b2_.email AS email_16, b2_.url AS url_17, b2_.commentText AS commentText_18, b2_.insert_date AS insert_date_19, b0_.category_id AS category_id_20, b0_.user_id AS user_id_21, b0_.image_id AS image_id_22 FROM blog_post b0_ LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id LEFT JOIN blogpostcomment_blogpost b3_ ON b0_.id = b3_.blogpost_id LEFT JOIN blog_post_comments b2_ ON b2_.id = b3_.blogpostcomment_id WHERE b1_.category_slug = ? AND b0_.is_publish = ? ORDER BY b0_.created_on DESC LIMIT 10 OFFSET 0
Parameters: [domain-names, 1]
|
3 | 0.49 ms |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.category_slug AS category_slug_3, t0.post_robots AS post_robots_4 FROM blog_post_category t0 WHERE t0.category_slug = ? LIMIT 1
Parameters: [domain-names]
|
4 | 1.79 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [12]
|
5 | 1.72 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [6]
|
6 | 0.98 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [1]
|
7 | 0.70 ms |
SELECT b0_.id AS id_0, b0_.post_title AS post_title_1, b0_.post_body AS post_body_2, b0_.post_slug AS post_slug_3, b0_.created_on AS created_on_4, b0_.updated_on AS updated_on_5, b0_.is_publish AS is_publish_6, b0_.post_robots AS post_robots_7, b0_.post_meta AS post_meta_8, b0_.views AS views_9, b1_.id AS id_10, b1_.category_name AS category_name_11, b1_.category_slug AS category_slug_12, b1_.post_robots AS post_robots_13, b0_.category_id AS category_id_14, b0_.user_id AS user_id_15, b0_.image_id AS image_id_16 FROM blog_post b0_ LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id WHERE b0_.is_publish = ? ORDER BY b0_.views DESC LIMIT 5
Parameters: [1]
|
8 | 0.63 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [150]
|
9 | 1.26 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [157]
|
10 | 1.04 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [26]
|
11 | 1.87 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [13]
|
12 | 2.42 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [22]
|
13 | 0.74 ms |
SELECT b0_.id AS id_0, b0_.post_title AS post_title_1, b0_.post_body AS post_body_2, b0_.post_slug AS post_slug_3, b0_.created_on AS created_on_4, b0_.updated_on AS updated_on_5, b0_.is_publish AS is_publish_6, b0_.post_robots AS post_robots_7, b0_.post_meta AS post_meta_8, b0_.views AS views_9, b1_.id AS id_10, b1_.category_name AS category_name_11, b1_.category_slug AS category_slug_12, b1_.post_robots AS post_robots_13, b0_.category_id AS category_id_14, b0_.user_id AS user_id_15, b0_.image_id AS image_id_16 FROM blog_post b0_ LEFT JOIN blog_post_category b1_ ON b0_.category_id = b1_.id WHERE b0_.is_publish = ? ORDER BY b0_.created_on DESC LIMIT 5
Parameters: [1]
|
14 | 0.72 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [148]
|
15 | 0.65 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [147]
|
16 | 0.54 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.data AS data_5, t0.post_id AS post_id_6 FROM blog_post_images t0 WHERE t0.id = ?
Parameters: [146]
|
17 | 0.42 ms |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.category_slug AS category_slug_3, t0.post_robots AS post_robots_4 FROM blog_post_category t0
Parameters: { }
|
Database Connections
Key | Value |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Key | Value |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
Conceptrix\BandVistaBundle\Entity\BlogPost |
|
Conceptrix\BandVistaBundle\Entity\BlogPostCategory | No errors. |
Conceptrix\BandVistaBundle\Entity\BlogPostComment |
|
Conceptrix\BandVistaBundle\Entity\Admin | No errors. |
Conceptrix\BandVistaBundle\Entity\BlogPostImage |
|
Conceptrix\BandVistaBundle\Entity\CronMails |
|