Query Metrics
7
Database Queries
7
Different statements
175.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.11 ms (84.39%) |
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 256821 410272 412288 419452 421573 421871 422158 425982 428315 428773 435024 439610 439623 439673 439696 440548 441645 446735 449086 454923 456885 458051 459513 460012 460314 462169 462171 462710 462845 463864 466229 466241 466271 466869 467108 473391 474901 475925 477079 480069 482808 483319 484644 484694 485269 486456 490409 490508 490905 491209 491446 494205 495559 502422 505132 506052 506612 510797 511359 512502 513572 514179 515761 517710 519572 519576 522663 522976 526981 531231 534109 537251 543307 544529 549976 553498 560029 560387 570151 572204 577400 578411 578454 581806 583508 584236 584301 584699 584886 586616 591416 592005 592340 600036 600070 605845 606806 609516 610317 617417 620320 623380 628126 631193 637389 639258 639722 651162 651933 661510 680484 681637 714925 720622 724305 743514 756840 759641 780873 811689 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (10.31%) |
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 494205 459513 484644 537251 637389 609516 623380 628126 410272 480069 506052 522663 549976 680484 606806 610317 425982 473391 440548 462171 491209 491446 515761 412288 519572 531231 483319 581806 586616 466241 466869 439673 466271 490409 435024 449086 463864 510797 462845 467108 560387 584886 577400 661510 651162 631193 419452 422158 439610 474901 495559 485269 421871 439623 714925 460314 526981 543307 553498 780873 759641 477079 578411 620320 441645 428315 512502 584301 592005 600070 592340 439696 458051 490508 490905 446735 454923 511359 600036 456885 421573 462710 502422 256821 460012 811689 584236 651933 617417 506612 486456 513572 505132 544529 681637 466229 475925 584699 756840 560029 583508 591416 724305 522976 605845 639722 482808 484694 720622 517710 578454 519576 639258 534109 514179 572204 570151 743514 462169 428773 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.50%) |
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 256821 410272 412288 419452 421573 421871 422158 425982 428315 428773 435024 439610 439623 439673 439696 440548 441645 446735 449086 454923 456885 458051 459513 460012 460314 462169 462171 462710 462845 463864 466229 466241 466271 466869 467108 473391 474901 475925 477079 480069 482808 483319 484644 484694 485269 486456 490409 490508 490905 491209 491446 494205 495559 502422 505132 506052 506612 510797 511359 512502 513572 514179 515761 517710 519572 519576 522663 522976 526981 531231 534109 537251 543307 544529 549976 553498 560029 560387 570151 572204 577400 578411 578454 581806 583508 584236 584301 584699 584886 586616 591416 592005 592340 600036 600070 605845 606806 609516 610317 617417 620320 623380 628126 631193 637389 639258 639722 651162 651933 661510 680484 681637 714925 720622 724305 743514 756840 759641 780873 811689 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal fucks"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал fucks"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал fucks"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.