Query Metrics
7
Database Queries
7
Different statements
138.03 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.42 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.84 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen fuck face"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.32 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 461090 700670 529105 668472 427553 618471 598103 600382 502239 456069 567608 651561 438725 518291 420785 460082 546215 784493 517305 445814 485998 620622 474279 514136 514443 528055 586665 517393 811845 543659 565243 486217 530771 537209 762217 420206 442968 485059 565201 445803 500896 459362 545601 568743 508438 447888 483321 474706 423893 447240 464365 490496 507511 561296 529556 530757 476520 525058 470829 519849 496270 503617 519556 537207 490508 519558 548226 632601 455195 514640 567837 589107 461375 562763 426551 677296 652236 605845 597491 608771 661565 526203 ] |
||||||||||||||||||||||||||||||
| 4 | 2.42 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 420206 420785 423893 426551 427553 438725 442968 445803 445814 447240 447888 455195 456069 459362 460082 461090 461375 464365 470829 474279 474706 476520 483321 485059 485998 486217 490496 490508 496270 500896 502239 503617 507511 508438 514136 514443 514640 517305 517393 518291 519556 519558 519849 525058 526203 528055 529105 529556 530757 530771 537207 537209 543659 545601 546215 548226 561296 562763 565201 565243 567608 567837 568743 586665 589107 597491 598103 600382 605845 608771 618471 620622 632601 651561 652236 661565 668472 677296 700670 762217 784493 811845 ] |
||||||||||||||||||||||||||||||
| 5 | 115.04 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 420206 420785 423893 426551 427553 438725 442968 445803 445814 447240 447888 455195 456069 459362 460082 461090 461375 464365 470829 474279 474706 476520 483321 485059 485998 486217 490496 490508 496270 500896 502239 503617 507511 508438 514136 514443 514640 517305 517393 518291 519556 519558 519849 525058 526203 528055 529105 529556 530757 530771 537207 537209 543659 545601 546215 548226 561296 562763 565201 565243 567608 567837 568743 586665 589107 597491 598103 600382 605845 608771 618471 620622 632601 651561 652236 661565 668472 677296 700670 762217 784493 811845 ] |
||||||||||||||||||||||||||||||
| 6 | 1.57 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen секс face"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.43 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen секс face"
]
|
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.