Query Metrics
7
Database Queries
7
Different statements
190.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.11 ms (86.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 383786 388847 411808 414368 426378 428425 429799 444464 448542 448806 451887 452117 457887 458523 458930 464124 464612 467047 470037 471176 471690 473451 473501 475410 478433 480300 480402 481820 485458 486426 487706 492576 497332 507939 513971 515370 516265 519437 523122 524245 527663 528299 528761 530510 530713 530765 531133 531188 531403 532363 532797 532833 532854 534641 534961 535593 536291 536318 536542 536550 537886 537932 540508 540575 542604 542610 543867 544753 544824 555872 555953 556806 565261 568543 569258 581384 585143 590394 591357 591668 594827 598286 599851 599994 600002 600008 600012 600269 600346 601316 602650 604310 604483 604558 612726 617429 618543 631199 631930 632970 634793 636280 639784 640795 645964 646243 649583 650470 651090 662604 666585 673035 688582 718979 720291 742428 756243 775056 788566 818439 ] |
||||||||||||||||||||||||||||||
|
16.65 ms (8.73%) |
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 631930 600012 617429 634793 448806 428425 497332 492576 486426 585143 458930 473501 599851 451887 481820 458523 464612 448542 471690 464124 556806 426378 444464 524245 487706 515370 388847 480300 532363 530510 530713 531133 531188 531403 532833 540508 543867 618543 591357 636280 600269 775056 645964 457887 485458 530765 532854 540575 542610 568543 651090 639784 590394 452117 475410 414368 516265 519437 528299 429799 473451 544824 569258 604483 612726 599994 600002 523122 527663 528761 535593 536542 507939 537932 480402 555872 542604 601316 594827 602650 470037 581384 411808 818439 513971 532797 536291 536318 536550 534961 537886 544753 650470 673035 649583 666585 662604 718979 640795 604558 632970 604310 631199 788566 756243 742428 720291 383786 555953 467047 478433 534641 565261 646243 688582 598286 600008 591668 600346 471176 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.56%) |
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 383786 388847 411808 414368 426378 428425 429799 444464 448542 448806 451887 452117 457887 458523 458930 464124 464612 467047 470037 471176 471690 473451 473501 475410 478433 480300 480402 481820 485458 486426 487706 492576 497332 507939 513971 515370 516265 519437 523122 524245 527663 528299 528761 530510 530713 530765 531133 531188 531403 532363 532797 532833 532854 534641 534961 535593 536291 536318 536542 536550 537886 537932 540508 540575 542604 542610 543867 544753 544824 555872 555953 556806 565261 568543 569258 581384 585143 590394 591357 591668 594827 598286 599851 599994 600002 600008 600012 600269 600346 601316 602650 604310 604483 604558 612726 617429 618543 631199 631930 632970 634793 636280 639784 640795 645964 646243 649583 650470 651090 662604 666585 673035 688582 718979 720291 742428 756243 775056 788566 818439 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кастинг с аналом женщин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг анал женщин"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.76%) |
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.