Query Metrics
7
Database Queries
7
Different statements
118.46 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.57 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.83 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"french teen anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.45 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 732303 447799 447832 767808 715098 708087 622688 800539 529035 583560 735776 819605 691225 654097 748715 815717 825689 724378 743057 819566 440817 124494 403150 626291 707609 621246 773998 639873 118086 486275 476962 619484 334376 581213 619485 512868 497507 602409 796970 487363 472951 619397 619470 405020 533576 608471 382438 404772 523420 410267 413597 819588 567503 413050 676097 635974 789494 729818 728035 493818 523442 461090 651627 500098 626297 445615 469357 429137 449435 474746 445652 461086 424329 446364 444542 463864 420406 522876 522556 541084 598133 448878 476409 506500 ] |
||||||||||||||||||||||||||||||
| 4 | 2.70 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 118086 124494 334376 382438 403150 404772 405020 410267 413050 413597 420406 424329 429137 440817 444542 445615 445652 446364 447799 447832 448878 449435 461086 461090 463864 469357 472951 474746 476409 476962 486275 487363 493818 497507 500098 506500 512868 522556 522876 523420 523442 529035 533576 541084 567503 581213 583560 598133 602409 608471 619397 619470 619484 619485 621246 622688 626291 626297 635974 639873 651627 654097 676097 691225 707609 708087 715098 724378 728035 729818 732303 735776 743057 748715 767808 773998 789494 796970 800539 815717 819566 819588 819605 825689 ] |
||||||||||||||||||||||||||||||
| 5 | 96.50 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 118086 124494 334376 382438 403150 404772 405020 410267 413050 413597 420406 424329 429137 440817 444542 445615 445652 446364 447799 447832 448878 449435 461086 461090 463864 469357 472951 474746 476409 476962 486275 487363 493818 497507 500098 506500 512868 522556 522876 523420 523442 529035 533576 541084 567503 581213 583560 598133 602409 608471 619397 619470 619484 619485 621246 622688 626291 626297 635974 639873 651627 654097 676097 691225 707609 708087 715098 724378 728035 729818 732303 735776 743057 748715 767808 773998 789494 796970 800539 815717 819566 819588 819605 825689 ] |
||||||||||||||||||||||||||||||
| 6 | 1.81 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"french teen анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.60 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"french teen анал"
]
|
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.