Query Metrics
7
Database Queries
7
Different statements
109.81 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.40 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.51 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"polish секс"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.25 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 790058 482950 645908 646208 589866 645935 645964 640703 646213 645946 645959 645891 645932 630770 522951 735578 757312 385228 681212 522958 645925 443469 566630 645949 589813 387490 396397 645951 504381 494000 645879 775893 735471 454857 645926 505566 645852 646183 455076 499207 646205 645917 399268 460359 451509 645878 445766 522499 491611 560143 542146 633140 218768 645920 510930 645822 811755 454856 443458 595782 493997 474625 443467 505572 430291 646202 485621 474619 507381 645898 494001 645937 634487 563337 645883 702061 470913 646199 580190 646214 763136 645936 443513 474649 460887 517932 605398 649123 468733 645918 ] |
||||||||||||||||||||||||||||||
| 4 | 1.88 ms |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 218768 385228 387490 396397 399268 430291 443458 443467 443469 443513 445766 451509 454856 454857 455076 460359 460887 468733 470913 474619 474625 474649 482950 485621 491611 493997 494000 494001 499207 504381 505566 505572 507381 510930 517932 522499 522951 522958 542146 560143 563337 566630 580190 589813 589866 595782 605398 630770 633140 634487 640703 645822 645852 645878 645879 645883 645891 645898 645908 645917 645918 645920 645925 645926 645932 645935 645936 645937 645946 645949 645951 645959 645964 646183 646199 646202 646205 646208 646213 646214 649123 681212 702061 735471 735578 757312 763136 775893 790058 811755 ] |
||||||||||||||||||||||||||||||
| 5 | 90.97 ms |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 218768 385228 387490 396397 399268 430291 443458 443467 443469 443513 445766 451509 454856 454857 455076 460359 460887 468733 470913 474619 474625 474649 482950 485621 491611 493997 494000 494001 499207 504381 505566 505572 507381 510930 517932 522499 522951 522958 542146 560143 563337 566630 580190 589813 589866 595782 605398 630770 633140 634487 640703 645822 645852 645878 645879 645883 645891 645898 645908 645917 645918 645920 645925 645926 645932 645935 645936 645937 645946 645949 645951 645959 645964 646183 646199 646202 646205 646208 646213 646214 649123 681212 702061 735471 735578 757312 763136 775893 790058 811755 ] |
||||||||||||||||||||||||||||||
| 6 | 1.52 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"polish секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.29 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"polish секс"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.