Query Metrics
7
Database Queries
7
Different statements
151.34 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.59 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.85 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mom real"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.69 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 544964 480417 647328 647609 814850 533848 443167 449764 576002 541074 631919 422159 421831 439770 433371 485057 516034 577620 400494 485064 521759 488772 524217 519512 541316 523907 539147 572697 668528 786552 572038 718798 728946 518159 750701 422151 454141 485037 600411 636598 579292 421878 421900 442613 444883 513750 421922 563875 517564 537672 623089 612053 525286 537670 650992 600995 586009 523840 540071 439764 433323 496518 606624 428756 529143 470302 594353 563787 639810 459513 532572 626136 527908 428761 572716 510254 604419 526951 568062 599967 577491 621764 513001 ] |
||||||||||||||||||||||||||||||
| 4 | 2.77 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 400494 421831 421878 421900 421922 422151 422159 428756 428761 433323 433371 439764 439770 442613 443167 444883 449764 454141 459513 470302 480417 485037 485057 485064 488772 496518 510254 513001 513750 516034 517564 518159 519512 521759 523840 523907 524217 525286 526951 527908 529143 532572 533848 537670 537672 539147 540071 541074 541316 544964 563787 563875 568062 572038 572697 572716 576002 577491 577620 579292 586009 594353 599967 600411 600995 604419 606624 612053 621764 623089 626136 631919 636598 639810 647328 647609 650992 668528 718798 728946 750701 786552 814850 ] |
||||||||||||||||||||||||||||||
| 5 | 125.27 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 400494 421831 421878 421900 421922 422151 422159 428756 428761 433323 433371 439764 439770 442613 443167 444883 449764 454141 459513 470302 480417 485037 485057 485064 488772 496518 510254 513001 513750 516034 517564 518159 519512 521759 523840 523907 524217 525286 526951 527908 529143 532572 533848 537670 537672 539147 540071 541074 541316 544964 563787 563875 568062 572038 572697 572716 576002 577491 577620 579292 586009 594353 599967 600411 600995 604419 606624 612053 621764 623089 626136 631919 636598 639810 647328 647609 650992 668528 718798 728946 750701 786552 814850 ] |
||||||||||||||||||||||||||||||
| 6 | 1.79 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom real"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.38 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom real"
]
|
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.