Query Metrics
7
Database Queries
7
Different statements
155.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.31 ms (82.07%) |
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 17093 69946 130429 324288 383188 385950 392333 395489 395549 395596 395819 396253 396568 396744 400642 401322 401334 401989 402199 404791 406324 406734 409106 414090 415189 415561 416523 416701 417811 419627 420741 421660 423488 424194 425189 427455 428583 430478 430695 433946 434456 437875 438464 444895 445439 445680 448816 451302 452149 454627 454668 456812 456907 457644 461437 461964 463873 465052 468113 470299 471077 471407 471919 474294 478006 478488 479847 480397 484879 485784 490854 491194 491614 497007 502843 502923 505684 508160 509085 510270 511828 512973 515468 516226 517727 517999 518269 518619 518995 519940 520736 521920 522451 522868 523420 524628 531219 537943 551107 552467 560653 561415 561621 561684 565958 568643 584558 592333 599361 600004 601994 607091 610683 621410 635834 705530 708790 722211 815016 816594 ] |
||||||||||||||||||||||||||||||
|
18.14 ms (11.69%) |
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 491194 510270 396253 434456 479847 485784 552467 463873 519940 505684 396568 400642 414090 478488 457644 497007 491614 551107 561621 705530 584558 635834 17093 395819 402199 423488 421660 471919 406734 470299 478006 437875 430478 430695 517999 537943 509085 521920 518995 524628 599361 448816 456812 621410 417811 420741 452149 395596 708790 560653 406324 419627 69946 401334 385950 383188 392333 324288 401989 428583 438464 531219 490854 561415 565958 568643 592333 600004 409106 415189 433946 456907 461964 471407 401322 424194 461437 396744 454627 480397 508160 511828 523420 502843 518619 522451 517727 522868 516226 561684 515468 404791 520736 512973 130429 395489 815016 816594 474294 465052 454668 471077 722211 601994 610683 607091 416701 445439 395549 444895 415561 416523 445680 468113 484879 518269 451302 427455 425189 502923 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.82%) |
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 17093 69946 130429 324288 383188 385950 392333 395489 395549 395596 395819 396253 396568 396744 400642 401322 401334 401989 402199 404791 406324 406734 409106 414090 415189 415561 416523 416701 417811 419627 420741 421660 423488 424194 425189 427455 428583 430478 430695 433946 434456 437875 438464 444895 445439 445680 448816 451302 452149 454627 454668 456812 456907 457644 461437 461964 463873 465052 468113 470299 471077 471407 471919 474294 478006 478488 479847 480397 484879 485784 490854 491194 491614 497007 502843 502923 505684 508160 509085 510270 511828 512973 515468 516226 517727 517999 518269 518619 518995 519940 520736 521920 522451 522868 523420 524628 531219 537943 551107 552467 560653 561415 561621 561684 565958 568643 584558 592333 599361 600004 601994 607091 610683 621410 635834 705530 708790 722211 815016 816594 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful blonde anal"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая беловолосая анал"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая беловолосая анал"
]
|
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.