Query Metrics
7
Database Queries
7
Different statements
118.27 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.61 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.70 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real milf blowjob"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.67 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 445661 608172 513498 504250 541316 421876 523907 426416 451639 509622 639810 539147 561273 502518 458191 599967 422155 433323 532572 569417 515538 486601 577400 459512 456695 579292 635074 421878 465075 563875 519561 681121 442613 523160 478379 421922 523171 623089 612053 653911 730798 453906 501251 518824 550099 563787 493310 462569 519589 428761 480417 446109 551997 608230 482534 598097 609531 457789 503194 428756 486862 497921 526951 595256 594353 427543 562361 572716 562790 489262 529290 626136 544686 588650 474663 567024 698124 608336 568062 597148 577491 550599 621764 527608 625440 ] |
||||||||||||||||||||||||||||||
| 4 | 2.86 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 421876 421878 421922 422155 426416 427543 428756 428761 433323 442613 445661 446109 451639 453906 456695 457789 458191 459512 462569 465075 474663 478379 480417 482534 486601 486862 489262 493310 497921 501251 502518 503194 504250 509622 513498 515538 518824 519561 519589 523160 523171 523907 526951 527608 529290 532572 539147 541316 544686 550099 550599 551997 561273 562361 562790 563787 563875 567024 568062 569417 572716 577400 577491 579292 588650 594353 595256 597148 598097 599967 608172 608230 608336 609531 612053 621764 623089 625440 626136 635074 639810 653911 681121 698124 730798 ] |
||||||||||||||||||||||||||||||
| 5 | 93.56 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 421876 421878 421922 422155 426416 427543 428756 428761 433323 442613 445661 446109 451639 453906 456695 457789 458191 459512 462569 465075 474663 478379 480417 482534 486601 486862 489262 493310 497921 501251 502518 503194 504250 509622 513498 515538 518824 519561 519589 523160 523171 523907 526951 527608 529290 532572 539147 541316 544686 550099 550599 551997 561273 562361 562790 563787 563875 567024 568062 569417 572716 577400 577491 579292 588650 594353 595256 597148 598097 599967 608172 608230 608336 609531 612053 621764 623089 625440 626136 635074 639810 653911 681121 698124 730798 ] |
||||||||||||||||||||||||||||||
| 6 | 1.43 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real milf минет оральн секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.44 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real 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.