Query Metrics
7
Database Queries
7
Different statements
182.35 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.53 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.99 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom anal fuck"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.40 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 522219 439684 535441 673988 401200 439771 608041 461364 493221 433249 553498 492563 484620 807327 522605 678800 606806 788136 421882 439816 433323 422158 481910 521149 605461 739532 481907 493212 795041 673960 439641 740958 588144 687661 506908 756491 463768 619513 465354 623362 462381 493222 431422 793818 439696 439785 556535 587987 439797 824388 605409 439819 741687 795709 564265 520142 805462 517015 463842 713176 578823 607537 684305 465248 422179 619536 400481 421876 523876 547546 515777 563546 546126 621339 573754 573742 628654 562894 619527 474783 619792 439720 623468 682531 582417 510371 400497 555181 ] |
||||||||||||||||||||||||||||||
| 4 | 2.33 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 400481 400497 401200 421876 421882 422158 422179 431422 433249 433323 439641 439684 439696 439720 439771 439785 439797 439816 439819 461364 462381 463768 463842 465248 465354 474783 481907 481910 484620 492563 493212 493221 493222 506908 510371 515777 517015 520142 521149 522219 522605 523876 535441 546126 547546 553498 555181 556535 562894 563546 564265 573742 573754 578823 582417 587987 588144 605409 605461 606806 607537 608041 619513 619527 619536 619792 621339 623362 623468 628654 673960 673988 678800 682531 684305 687661 713176 739532 740958 741687 756491 788136 793818 795041 795709 805462 807327 824388 ] |
||||||||||||||||||||||||||||||
| 5 | 158.77 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 400481 400497 401200 421876 421882 422158 422179 431422 433249 433323 439641 439684 439696 439720 439771 439785 439797 439816 439819 461364 462381 463768 463842 465248 465354 474783 481907 481910 484620 492563 493212 493221 493222 506908 510371 515777 517015 520142 521149 522219 522605 523876 535441 546126 547546 553498 555181 556535 562894 563546 564265 573742 573754 578823 582417 587987 588144 605409 605461 606806 607537 608041 619513 619527 619536 619792 621339 623362 623468 628654 673960 673988 678800 682531 684305 687661 713176 739532 740958 741687 756491 788136 793818 795041 795709 805462 807327 824388 ] |
||||||||||||||||||||||||||||||
| 6 | 1.57 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom анал секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.75 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom анал секс"
]
|
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.