Query Metrics
7
Database Queries
7
Different statements
171.92 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.16 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits yoga"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.37 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 743108 469575 420268 468832 525773 459908 464082 595763 458509 496644 489639 556010 633529 459983 487808 559222 463368 462644 472243 458805 500525 586152 587935 799190 479798 428499 417136 429709 513449 458222 640708 520800 515567 512121 533126 557657 529306 581730 307654 451002 427845 510965 448465 558625 457170 635920 500067 514377 484791 422098 518248 416817 512876 454099 483039 454788 435225 449499 435505 555140 598076 635234 419138 815108 578451 463694 463544 463561 499594 503967 510194 498033 464857 635188 529213 430071 482622 515802 529212 659407 519087 596168 577931 599694 383616 679076 561936 556489 602945 ] |
||||||||||||||||||||||||||||||
| 4 | 2.67 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 307654 383616 416817 417136 419138 420268 422098 427845 428499 429709 430071 435225 435505 448465 449499 451002 454099 454788 457170 458222 458509 458805 459908 462644 463368 463544 463561 463694 464082 464857 468832 469575 472243 479798 482622 483039 484791 487808 489639 496644 498033 499594 500067 500525 503967 510194 510965 512121 512876 513449 514377 515567 515802 518248 519087 520800 525773 529212 529213 529306 533126 555140 556010 556489 557657 558625 559222 561936 577931 578451 581730 586152 587935 595763 596168 598076 599694 602945 633529 635188 635234 635920 640708 659407 679076 743108 799190 815108 ] |
||||||||||||||||||||||||||||||
| 5 | 146.21 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 307654 383616 416817 417136 419138 420268 422098 427845 428499 429709 430071 435225 435505 448465 449499 451002 454099 454788 457170 458222 458509 458805 459908 462644 463368 463544 463561 463694 464082 464857 468832 469575 472243 479798 482622 483039 484791 487808 489639 496644 498033 499594 500067 500525 503967 510194 510965 512121 512876 513449 514377 515567 515802 518248 519087 520800 525773 529212 529213 529306 533126 555140 556010 556489 557657 558625 559222 561936 577931 578451 581730 586152 587935 595763 596168 598076 599694 602945 633529 635188 635234 635920 640708 659407 679076 743108 799190 815108 ] |
||||||||||||||||||||||||||||||
| 6 | 1.89 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ yoga"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.86 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ yoga"
]
|
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.