Query Metrics
7
Database Queries
7
Different statements
259.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
233.42 ms (89.88%) |
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 398477 400581 405708 417647 418165 418440 423424 426220 428965 432374 433330 433792 434442 436656 439440 442367 445883 446356 448280 450953 455875 458220 459382 459615 460062 467561 469200 469749 469751 470910 471991 475195 476828 495401 496088 496451 503105 504661 505619 508168 509672 514357 516256 519261 519556 519577 524751 525409 530484 530690 530757 530768 531108 531115 531145 532349 532625 532753 533073 533760 535038 535056 535597 536215 536687 537207 538761 541197 541201 542516 542583 542595 543627 544659 547366 548254 548538 552659 553103 564407 567777 568111 568580 572961 576030 616869 622401 624127 624346 631195 632594 632611 637043 637063 637141 643125 646935 647914 649110 651168 666899 666901 666903 666904 676112 676638 678127 680118 685714 696204 696579 703831 714109 717318 724164 724209 757355 762213 762217 ] |
||||||||||||||||||||||||||||||
|
16.31 ms (6.28%) |
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 442367 505619 536215 547366 553103 624346 530690 564407 568111 418440 426220 433792 417647 433330 445883 467561 532625 503105 531108 531145 508168 530484 538761 496088 567777 552659 576030 651168 714109 649110 572961 637141 807580 724209 724164 757355 762213 632611 428965 432374 436656 469200 470910 471991 439440 459615 469749 475195 450953 455875 460062 469751 496451 519577 524751 514357 476828 533073 548254 568580 400581 519556 537207 548538 542516 423424 434442 446356 448280 519261 530768 531115 532349 533760 535038 535597 542583 541201 542595 543627 666899 646935 647914 666903 631195 632594 637063 622401 637043 616869 624127 643125 762217 717318 458220 418165 459382 509672 504661 495401 516256 525409 405708 398477 676638 532753 530757 535056 536687 541197 666904 696579 666901 676112 678127 696204 703831 680118 685714 544659 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.14%) |
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 398477 400581 405708 417647 418165 418440 423424 426220 428965 432374 433330 433792 434442 436656 439440 442367 445883 446356 448280 450953 455875 458220 459382 459615 460062 467561 469200 469749 469751 470910 471991 475195 476828 495401 496088 496451 503105 504661 505619 508168 509672 514357 516256 519261 519556 519577 524751 525409 530484 530690 530757 530768 531108 531115 531145 532349 532625 532753 533073 533760 535038 535056 535597 536215 536687 537207 538761 541197 541201 542516 542583 542595 543627 544659 547366 548254 548538 552659 553103 564407 567777 568111 568580 572961 576030 616869 622401 624127 624346 631195 632594 632611 637043 637063 637141 643125 646935 647914 649110 651168 666899 666901 666903 666904 676112 676638 678127 680118 685714 696204 696579 703831 714109 717318 724164 724209 757355 762213 762217 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tattoo teen cum"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"татуированные teen cum"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"татуированные teen cum"
]
|
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.