Query Metrics
7
Database Queries
7
Different statements
169.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.40 ms (83.86%) |
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 68292 79331 92307 156348 188014 384760 385271 390583 391836 392063 392068 393148 398188 407516 410699 416294 416887 418046 423586 423957 426722 434887 437736 438690 440721 443097 443754 445880 451007 454181 455177 455649 455882 456834 457159 459564 460081 460398 460491 461044 461809 462276 462300 464710 465123 466299 466885 468469 469842 471380 475027 477407 479236 480483 486013 486357 486524 488294 490878 493121 493210 493328 494987 495280 495281 495409 495957 495970 497232 499589 504709 505459 507124 507790 509209 510475 514062 517000 517172 518597 519037 522279 524786 526930 527150 533613 535058 544184 545778 549174 552758 559079 565185 570664 573248 573368 574460 579126 591961 595633 599317 601489 601891 601976 609628 611251 613401 617784 618371 618789 620086 620667 621587 646581 653850 683010 700715 754800 790261 797935 ] |
||||||||||||||||||||||||||||||
|
18.38 ms (10.83%) |
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 493121 519037 617784 524786 574460 514062 493210 494987 618371 621587 466885 471380 533613 601489 618789 565185 613401 601976 457159 611251 620086 620667 518597 599317 517000 504709 469842 683010 591961 573248 456834 79331 545778 68292 156348 493328 790261 495970 754800 391836 392063 437736 460398 480483 384760 393148 438690 416887 461044 653850 440721 465123 462276 418046 392068 443754 410699 609628 423586 505459 517172 455882 646581 507124 595633 486357 468469 601891 535058 188014 527150 455177 486524 451007 499589 434887 495409 475027 385271 797935 423957 416294 461809 466299 454181 495957 479236 495280 507790 509209 92307 490878 460491 460081 700715 455649 390583 544184 552758 477407 398188 407516 510475 462300 488294 464710 495281 486013 573368 549174 579126 526930 445880 522279 559079 426722 497232 443097 459564 570664 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.49%) |
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 68292 79331 92307 156348 188014 384760 385271 390583 391836 392063 392068 393148 398188 407516 410699 416294 416887 418046 423586 423957 426722 434887 437736 438690 440721 443097 443754 445880 451007 454181 455177 455649 455882 456834 457159 459564 460081 460398 460491 461044 461809 462276 462300 464710 465123 466299 466885 468469 469842 471380 475027 477407 479236 480483 486013 486357 486524 488294 490878 493121 493210 493328 494987 495280 495281 495409 495957 495970 497232 499589 504709 505459 507124 507790 509209 510475 514062 517000 517172 518597 519037 522279 524786 526930 527150 533613 535058 544184 545778 549174 552758 559079 565185 570664 573248 573368 574460 579126 591961 595633 599317 601489 601891 601976 609628 611251 613401 617784 618371 618789 620086 620667 621587 646581 653850 683010 700715 754800 790261 797935 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс презик"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс презерват"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.80%) |
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.