Query Metrics
7
Database Queries
7
Different statements
197.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.59 ms (87.90%) |
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 233622 401225 418730 427407 452534 464809 465015 470570 480083 482770 493609 494528 495531 500381 501513 502376 504081 510556 512144 513586 513809 517719 519828 524465 524602 526465 527240 527771 527887 527981 528511 530101 530252 530259 530622 531650 532187 533140 535145 535277 537411 541963 542876 545170 545491 546084 547078 547200 548130 548941 551727 551843 552283 556167 556172 556185 557888 558794 559468 560000 561163 561703 562097 562929 564633 566285 567090 567603 567614 568136 568765 570991 571472 571475 572896 574970 577570 578598 581186 581558 582036 582941 583660 584183 585004 586706 588328 590124 591395 591857 596126 601778 602269 602543 603189 603318 603414 604943 616832 617882 623870 628525 628655 630470 630726 637494 641408 641560 644885 648875 652701 653885 666030 669912 680650 682409 691171 701621 723601 788102 ] |
||||||||||||||||||||||||||||||
|
13.78 ms (6.98%) |
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 524465 535277 564633 556185 560000 583660 556167 591395 604943 623870 630470 637494 524602 493609 530101 494528 504081 530622 572896 559468 545491 561703 581558 548130 548941 558794 602543 628525 641560 630726 526465 418730 427407 644885 482770 470570 452534 512144 500381 519828 527771 535145 527887 530259 533140 464809 547078 557888 561163 574970 581186 568765 577570 582036 542876 547200 570991 648875 666030 653885 669912 652701 680650 682409 691171 701621 545170 566285 568136 578598 584183 588328 596126 602269 603189 628655 590124 601778 603318 641408 591857 586706 616832 617882 788102 603414 233622 527981 401225 585004 723601 562097 465015 510556 513586 513809 517719 501513 502376 531650 532187 537411 495531 527240 528511 530252 480083 541963 552283 562929 567090 567603 567614 571472 546084 551843 556172 571475 582941 551727 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.27%) |
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 233622 401225 418730 427407 452534 464809 465015 470570 480083 482770 493609 494528 495531 500381 501513 502376 504081 510556 512144 513586 513809 517719 519828 524465 524602 526465 527240 527771 527887 527981 528511 530101 530252 530259 530622 531650 532187 533140 535145 535277 537411 541963 542876 545170 545491 546084 547078 547200 548130 548941 551727 551843 552283 556167 556172 556185 557888 558794 559468 560000 561163 561703 562097 562929 564633 566285 567090 567603 567614 568136 568765 570991 571472 571475 572896 574970 577570 578598 581186 581558 582036 582941 583660 584183 585004 586706 588328 590124 591395 591857 596126 601778 602269 602543 603189 603318 603414 604943 616832 617882 623870 628525 628655 630470 630726 637494 641408 641560 644885 648875 652701 653885 666030 669912 680650 682409 691171 701621 723601 788102 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl telephone"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк телефон"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
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.