Query Metrics
7
Database Queries
7
Different statements
119.84 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.49 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.83 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife perfect tits"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.17 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 799190 454492 454943 444903 479877 512017 503895 521412 607694 463368 525729 700307 589795 624909 397349 437635 427882 464985 479641 521045 34452 498417 589105 486869 489963 498402 523035 589972 423298 527681 590079 599159 427845 456839 513502 520838 521049 498539 666125 548862 612074 771517 516870 497117 516298 518364 811466 437797 493464 522523 504989 409894 498110 503385 515523 477772 416405 498014 511359 460803 512844 525474 498563 479936 552355 594422 514977 624390 548866 510194 483851 588039 487087 598289 613508 524087 498591 564981 529125 489980 601161 496853 589544 516227 521843 523809 420262 618326 ] |
||||||||||||||||||||||||||||||
| 4 | 3.45 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 34452 397349 409894 416405 420262 423298 427845 427882 437635 437797 444903 454492 454943 456839 460803 463368 464985 477772 479641 479877 479936 483851 486869 487087 489963 489980 493464 496853 497117 498014 498110 498402 498417 498539 498563 498591 503385 503895 504989 510194 511359 512017 512844 513502 514977 515523 516227 516298 516870 518364 520838 521045 521049 521412 521843 522523 523035 523809 524087 525474 525729 527681 529125 548862 548866 552355 564981 588039 589105 589544 589795 589972 590079 594422 598289 599159 601161 607694 612074 613508 618326 624390 624909 666125 700307 771517 799190 811466 ] |
||||||||||||||||||||||||||||||
| 5 | 94.66 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 34452 397349 409894 416405 420262 423298 427845 427882 437635 437797 444903 454492 454943 456839 460803 463368 464985 477772 479641 479877 479936 483851 486869 487087 489963 489980 493464 496853 497117 498014 498110 498402 498417 498539 498563 498591 503385 503895 504989 510194 511359 512017 512844 513502 514977 515523 516227 516298 516870 518364 520838 521045 521049 521412 521843 522523 523035 523809 524087 525474 525729 527681 529125 548862 548866 552355 564981 588039 589105 589544 589795 589972 590079 594422 598289 599159 601161 607694 612074 613508 618326 624390 624909 666125 700307 771517 799190 811466 ] |
||||||||||||||||||||||||||||||
| 6 | 1.66 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен perfect сиськ"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.58 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен perfect сиськ"
]
|
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.