Query Metrics
7
Database Queries
7
Different statements
252.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
227.80 ms (90.34%) |
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 7748 21711 37232 174164 293121 323352 361679 370928 382018 385496 391812 396476 397812 403064 413576 417788 423799 427813 432573 433541 437564 441265 445034 450438 450588 452184 453545 453944 457657 457696 458371 461814 463827 464563 465703 465874 468407 471477 473302 474224 474822 480434 480889 481192 481430 481501 482095 483273 485605 486053 486423 486518 488982 490257 492304 496009 497241 498667 501717 506259 509202 509971 510926 513163 514207 518642 519794 521864 525304 525306 527461 527595 530032 532299 533091 533467 535905 535984 539626 544552 544704 551691 552079 560850 566980 569803 569811 570615 571467 571596 571647 572266 572799 581341 585420 588662 588926 591756 595150 597126 602575 605370 612445 619728 622309 644626 650076 651548 656744 668740 678180 689113 717139 727421 749601 782852 786465 790889 819899 ] |
||||||||||||||||||||||||||||||
|
14.49 ms (5.75%) |
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 588926 480434 597126 612445 525306 530032 396476 544552 551691 569811 689113 717139 622309 588662 782852 370928 7748 391812 385496 509202 527595 452184 450438 473302 501717 519794 174164 397812 432573 427813 437564 453944 525304 527461 513163 535905 486053 490257 569803 651548 668740 656744 585420 790889 727421 423799 485605 486423 445034 463827 483273 482095 544704 650076 749601 450588 461814 525060 498667 819899 786465 382018 488982 458371 571647 571596 552079 566980 678180 591756 595150 457657 433541 572266 560850 602575 403064 457696 481501 468407 521864 619728 506259 605370 453545 480889 486518 492304 532299 535984 514207 518642 465703 474822 571467 570615 441265 464563 465874 481430 481192 496009 497241 510926 581341 644626 533467 323352 293121 361679 21711 37232 413576 417788 474224 471477 539626 533091 509971 572799 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.07%) |
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 7748 21711 37232 174164 293121 323352 361679 370928 382018 385496 391812 396476 397812 403064 413576 417788 423799 427813 432573 433541 437564 441265 445034 450438 450588 452184 453545 453944 457657 457696 458371 461814 463827 464563 465703 465874 468407 471477 473302 474224 474822 480434 480889 481192 481430 481501 482095 483273 485605 486053 486423 486518 488982 490257 492304 496009 497241 498667 501717 506259 509202 509971 510926 513163 514207 518642 519794 521864 525304 525306 527461 527595 530032 532299 533091 533467 535905 535984 539626 544552 544704 551691 552079 560850 566980 569803 569811 570615 571467 571596 571647 572266 572799 581341 585420 588662 588926 591756 595150 597126 602575 605370 612445 619728 622309 644626 650076 651548 656744 668740 678180 689113 717139 727421 749601 782852 786465 790889 819899 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding dick"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз член"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"наездниц поз член"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.58%) |
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.