Query Metrics
7
Database Queries
7
Different statements
365.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.44 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.03 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short hairy milf"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.14 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 479040 518563 484556 484670 484459 454221 484727 475691 472650 554205 442332 476107 483152 469520 468955 534334 533802 481463 486179 493222 576691 576704 541408 541592 578257 584724 424460 443704 443737 443796 443822 458191 470254 403879 444238 468941 519942 484475 504399 504738 484432 527980 466982 447978 454210 501242 563093 566252 660747 688007 607630 724305 727812 809930 443831 466097 466112 484684 502794 508662 535460 481163 541593 639796 462321 513025 484681 451957 482527 571428 541683 650851 574200 576710 470596 445471 528089 466180 541588 647860 591314 469534 475891 554787 560340 604429 ] |
||||||||||||||||||||||||||||||
| 4 | 2.71 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 403879 424460 442332 443704 443737 443796 443822 443831 444238 445471 447978 451957 454210 454221 458191 462321 466097 466112 466180 466982 468941 468955 469520 469534 470254 470596 472650 475691 475891 476107 479040 481163 481463 482527 483152 484432 484459 484475 484556 484670 484681 484684 484727 486179 493222 501242 502794 504399 504738 508662 513025 518563 519942 527980 528089 533802 534334 535460 541408 541588 541592 541593 541683 554205 554787 560340 563093 566252 571428 574200 576691 576704 576710 578257 584724 591314 604429 607630 639796 647860 650851 660747 688007 724305 727812 809930 ] |
||||||||||||||||||||||||||||||
| 5 | 340.61 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 403879 424460 442332 443704 443737 443796 443822 443831 444238 445471 447978 451957 454210 454221 458191 462321 466097 466112 466180 466982 468941 468955 469520 469534 470254 470596 472650 475691 475891 476107 479040 481163 481463 482527 483152 484432 484459 484475 484556 484670 484681 484684 484727 486179 493222 501242 502794 504399 504738 508662 513025 518563 519942 527980 528089 533802 534334 535460 541408 541588 541592 541593 541683 554205 554787 560340 563093 566252 571428 574200 576691 576704 576710 578257 584724 591314 604429 607630 639796 647860 650851 660747 688007 724305 727812 809930 ] |
||||||||||||||||||||||||||||||
| 6 | 1.58 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short волосатая milf"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.34 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short волосатая milf"
]
|
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.