Query Metrics
7
Database Queries
7
Different statements
168.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.42 ms (83.22%) |
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 388856 397509 413381 426647 428750 430559 435722 437605 439353 448140 448570 449586 451073 452791 452823 453222 455608 457214 457957 458870 460351 468165 469404 469463 469619 471145 471153 473511 475404 475752 479990 480207 486004 486829 490949 490953 494491 495568 497829 498473 511455 516941 520491 521431 521559 521775 529154 546381 547235 554551 556202 559216 561909 561919 562784 566784 568075 568301 569233 569614 571975 572778 572784 576604 580180 580194 582526 584337 588520 590377 590977 592500 594975 596649 602136 602296 620253 621742 626588 633147 639782 640152 651161 665226 665957 673797 680484 692711 696154 706359 730011 755350 757427 770228 770387 776400 777012 777051 781792 782653 785877 786604 798685 799268 800031 800293 802114 802817 803603 805366 805543 806271 806580 807219 807595 809434 811233 815559 816547 819565 ] |
||||||||||||||||||||||||||||||
|
18.81 ms (11.15%) |
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 811233 770228 468165 680484 590377 806580 486829 413381 435722 455608 521431 494491 561919 580180 665957 568301 576604 596649 626588 594975 479990 471145 430559 480207 448570 457214 475404 511455 490953 495568 520491 529154 473511 448140 452823 475752 640152 388856 469463 437605 426647 490949 497829 516941 486004 588520 819565 815559 816547 449586 469404 498473 521775 521559 471153 546381 547235 559216 562784 569233 571975 572778 572784 580194 556202 582526 584337 554551 561909 568075 569614 665226 696154 706359 651161 673797 692711 566784 592500 602136 590977 639782 776400 777051 781792 782653 786604 806271 807595 777012 800293 805366 807219 785877 798685 799268 800031 803603 805543 730011 755350 757427 770387 602296 620253 621742 633147 802114 802817 809434 397509 439353 453222 457957 469619 458870 460351 428750 451073 452791 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.44%) |
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 388856 397509 413381 426647 428750 430559 435722 437605 439353 448140 448570 449586 451073 452791 452823 453222 455608 457214 457957 458870 460351 468165 469404 469463 469619 471145 471153 473511 475404 475752 479990 480207 486004 486829 490949 490953 494491 495568 497829 498473 511455 516941 520491 521431 521559 521775 529154 546381 547235 554551 556202 559216 561909 561919 562784 566784 568075 568301 569233 569614 571975 572778 572784 576604 580180 580194 582526 584337 588520 590377 590977 592500 594975 596649 602136 602296 620253 621742 626588 633147 639782 640152 651161 665226 665957 673797 680484 692711 696154 706359 730011 755350 757427 770228 770387 776400 777012 777051 781792 782653 785877 786604 798685 799268 800031 800293 802114 802817 803603 805366 805543 806271 806580 807219 807595 809434 811233 815559 816547 819565 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo beauty"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд beauty"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд beauty"
]
|
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.