Query Metrics
7
Database Queries
7
Different statements
118.62 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.80 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.29 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian anal mom"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.91 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 327421 457980 774690 807641 815165 598344 556428 786454 559162 590812 418188 770304 776184 586002 815151 415950 821536 815022 406030 697354 559161 642064 641455 451259 490956 810813 433200 805431 752759 815674 820070 765721 519437 815270 818442 665930 721711 670625 801880 809157 46580 643072 816259 571232 575300 583996 815019 522795 820767 544753 636371 810840 816991 776532 580255 454812 414126 457890 568034 556421 622990 599953 640534 779560 815137 632571 814845 532264 636290 519497 646025 642063 614993 532751 649559 544281 532812 785525 582540 541774 542189 665781 544964 609121 677712 534023 541863 623261 ] |
||||||||||||||||||||||||||||||
| 4 | 2.77 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 46580 327421 406030 414126 415950 418188 433200 451259 454812 457890 457980 490956 519437 519497 522795 532264 532751 532812 534023 541774 541863 542189 544281 544753 544964 556421 556428 559161 559162 568034 571232 575300 580255 582540 583996 586002 590812 598344 599953 609121 614993 622990 623261 632571 636290 636371 640534 641455 642063 642064 643072 646025 649559 665781 665930 670625 677712 697354 721711 752759 765721 770304 774690 776184 776532 779560 785525 786454 801880 805431 807641 809157 810813 810840 814845 815019 815022 815137 815151 815165 815270 815674 816259 816991 818442 820070 820767 821536 ] |
||||||||||||||||||||||||||||||
| 5 | 94.53 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 46580 327421 406030 414126 415950 418188 433200 451259 454812 457890 457980 490956 519437 519497 522795 532264 532751 532812 534023 541774 541863 542189 544281 544753 544964 556421 556428 559161 559162 568034 571232 575300 580255 582540 583996 586002 590812 598344 599953 609121 614993 622990 623261 632571 636290 636371 640534 641455 642063 642064 643072 646025 649559 665781 665930 670625 677712 697354 721711 752759 765721 770304 774690 776184 776532 779560 785525 786454 801880 805431 807641 809157 810813 810840 814845 815019 815022 815137 815151 815165 815270 815674 816259 816991 818442 820070 820767 821536 ] |
||||||||||||||||||||||||||||||
| 6 | 1.76 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк анал mom"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.55 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк анал mom"
]
|
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.