Query Metrics
7
Database Queries
7
Different statements
115.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.83 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.15 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding mom cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.33 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 529250 485285 512717 520028 523859 528157 539248 541728 630781 596424 437818 815017 815935 447182 463511 531468 683902 688664 646786 681584 604524 610271 598852 808526 603247 619483 701337 446173 433189 540155 491446 517844 535456 495778 501240 531516 531431 531506 571028 584063 562355 563218 541923 670951 699397 646849 578300 583533 634472 596571 599610 502794 522871 550571 564137 565050 571680 604517 447677 504922 517301 519198 531511 542148 606687 639744 590993 601485 593343 602981 587266 634218 620871 525116 504693 517743 523767 513001 540153 533915 584720 591739 606697 624226 ] |
||||||||||||||||||||||||||||||
| 4 | 2.31 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 433189 437818 446173 447182 447677 463511 485285 491446 495778 501240 502794 504693 504922 512717 513001 517301 517743 517844 519198 520028 522871 523767 523859 525116 528157 529250 531431 531468 531506 531511 531516 533915 535456 539248 540153 540155 541728 541923 542148 550571 562355 563218 564137 565050 571028 571680 578300 583533 584063 584720 587266 590993 591739 593343 596424 596571 598852 599610 601485 602981 603247 604517 604524 606687 606697 610271 619483 620871 624226 630781 634218 634472 639744 646786 646849 670951 681584 683902 688664 699397 701337 808526 815017 815935 ] |
||||||||||||||||||||||||||||||
| 5 | 87.78 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 433189 437818 446173 447182 447677 463511 485285 491446 495778 501240 502794 504693 504922 512717 513001 517301 517743 517844 519198 520028 522871 523767 523859 525116 528157 529250 531431 531468 531506 531511 531516 533915 535456 539248 540153 540155 541728 541923 542148 550571 562355 563218 564137 565050 571028 571680 578300 583533 584063 584720 587266 590993 591739 593343 596424 596571 598852 599610 601485 602981 603247 604517 604524 606687 606697 610271 619483 620871 624226 630781 634218 634472 639744 646786 646849 670951 681584 683902 688664 699397 701337 808526 815017 815935 ] |
||||||||||||||||||||||||||||||
| 6 | 1.48 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding mom cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.71 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding mom cock"
]
|
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.