Query Metrics
7
Database Queries
7
Different statements
213.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.04 ms (87.08%) |
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 382898 398685 401243 411462 418796 422099 425502 426277 435355 453216 454515 456667 463313 466759 467005 469173 469892 478770 486738 494165 495865 499549 521853 529628 529916 529990 530133 530398 530972 531054 533070 533296 533647 534668 537097 538634 539438 540782 542448 542453 542459 544024 546046 546154 547943 548898 550110 554998 555137 555784 556756 557532 563346 567793 574768 574969 575297 575400 575873 575947 576465 579119 583182 585081 588420 589697 589978 592938 600438 601738 603961 605074 605710 607565 607593 608188 613513 634414 636493 637462 671219 680806 686352 697594 706021 706635 708933 712258 725492 731544 732855 738098 739964 742104 751447 753692 768460 770055 780354 783210 783954 784122 788802 789259 791026 793136 803823 810483 812232 814298 816117 816686 818574 819117 823902 825677 826700 826914 827243 827559 ] |
||||||||||||||||||||||||||||||
|
15.65 ms (7.32%) |
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 725492 456667 592938 425502 411462 546046 783954 739964 398685 422099 467005 486738 494165 567793 601738 589978 469173 466759 539438 521853 555137 435355 544024 574768 537097 607593 589697 556756 636493 706021 810483 793136 731544 789259 697594 529990 529916 575400 583182 712258 680806 686352 708933 605710 607565 608188 603961 634414 742104 803823 812232 770055 751447 791026 454515 401243 463313 768460 555784 671219 554998 600438 605074 588420 469892 426277 453216 575947 382898 418796 478770 637462 780354 732855 738098 783210 788802 753692 706635 784122 499549 613513 816686 825677 585081 540782 826700 819117 823902 826914 827243 818574 814298 816117 827559 530398 531054 533070 533296 538634 495865 529628 530133 530972 533647 534668 542453 546154 547943 550110 576465 542448 574969 575873 542459 548898 557532 563346 575297 579119 ] |
||||||||||||||||||||||||||||||
|
4.83 ms (2.26%) |
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 382898 398685 401243 411462 418796 422099 425502 426277 435355 453216 454515 456667 463313 466759 467005 469173 469892 478770 486738 494165 495865 499549 521853 529628 529916 529990 530133 530398 530972 531054 533070 533296 533647 534668 537097 538634 539438 540782 542448 542453 542459 544024 546046 546154 547943 548898 550110 554998 555137 555784 556756 557532 563346 567793 574768 574969 575297 575400 575873 575947 576465 579119 583182 585081 588420 589697 589978 592938 600438 601738 603961 605074 605710 607565 607593 608188 613513 634414 636493 637462 671219 680806 686352 697594 706021 706635 708933 712258 725492 731544 732855 738098 739964 742104 751447 753692 768460 770055 780354 783210 783954 784122 788802 789259 791026 793136 803823 810483 812232 814298 816117 816686 818574 819117 823902 825677 826700 826914 827243 827559 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo panties wife"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло трусик нижн бел жен"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло трусик нижн бел жен"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.69%) |
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.