Query Metrics
7
Database Queries
7
Different statements
152.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.81 ms (82.99%) |
1 |
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 43271 96200 97098 157194 162000 181422 280674 304572 390303 395276 395596 395661 395861 399688 401114 401470 403588 405485 405859 407378 407570 409179 412273 413112 413183 413518 419527 419880 428062 428539 445236 452136 452149 454350 456600 464157 464210 465707 466248 466690 466721 469509 469534 470290 471814 472641 472869 474292 474463 478006 478740 478963 479112 480380 482981 483150 484688 484738 485125 490430 491837 491906 491916 493899 496724 497007 510132 511827 512526 513983 515611 516509 516656 519233 522614 532746 535264 536443 544125 555125 555992 562791 565257 565724 574109 582404 584246 588082 593236 598115 605144 646279 663162 674770 681085 683284 699549 717677 724996 726282 761590 777361 781326 781359 782650 787857 789986 794366 796920 797504 798942 800785 804308 805110 810402 816635 821726 822278 822585 827829 ] |
||||||||||||||||||||||||||||||
|
15.35 ms (10.05%) |
1 |
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 588082 413112 466690 395861 584246 726282 493899 395276 162000 412273 717677 605144 761590 454350 390303 491837 469534 804308 565257 395661 403588 511827 407570 482981 532746 646279 598115 452149 456600 480380 483150 565724 157194 491906 535264 536443 490430 280674 409179 555992 544125 781326 304572 181422 794366 405485 419880 96200 474292 663162 593236 797504 787857 810402 413183 478740 522614 510132 405859 479112 674770 800785 574109 724996 816635 515611 469509 484738 827829 485125 464157 399688 419527 471814 516656 519233 395596 452136 484688 401114 464210 470290 413518 512526 562791 472641 445236 491916 428539 699549 555125 513983 681085 805110 777361 97098 407378 466721 497007 516509 465707 582404 401470 466248 472869 474463 478006 43271 496724 822278 822585 789986 478963 428062 821726 683284 782650 798942 781359 796920 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.09%) |
1 |
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 43271 96200 97098 157194 162000 181422 280674 304572 390303 395276 395596 395661 395861 399688 401114 401470 403588 405485 405859 407378 407570 409179 412273 413112 413183 413518 419527 419880 428062 428539 445236 452136 452149 454350 456600 464157 464210 465707 466248 466690 466721 469509 469534 470290 471814 472641 472869 474292 474463 478006 478740 478963 479112 480380 482981 483150 484688 484738 485125 490430 491837 491906 491916 493899 496724 497007 510132 511827 512526 513983 515611 516509 516656 519233 522614 532746 535264 536443 544125 555125 555992 562791 565257 565724 574109 582404 584246 588082 593236 598115 605144 646279 663162 674770 681085 683284 699549 717677 724996 726282 761590 777361 781326 781359 782650 787857 789986 794366 796920 797504 798942 800785 804308 805110 810402 816635 821726 822278 822585 827829 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature beautiful anal"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature красивая анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature красивая анал"
]
|
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.