Query Metrics
7
Database Queries
7
Different statements
200.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.77 ms (87.24%) |
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 70131 188240 191343 233179 311007 369353 382993 385386 385528 385826 385991 386576 387951 388333 390150 390851 391427 391980 393245 396865 398231 398551 398560 398564 398567 407790 409945 411628 411631 411723 411769 411794 429239 443681 444117 448619 450122 450156 450183 451606 452185 454408 455872 459764 462104 466789 466823 466903 466983 467032 467095 467239 469360 469387 472650 472696 474393 474876 475298 477208 477645 480490 485210 488311 491109 499274 500905 500938 502028 503801 506846 507691 508162 510925 514885 515074 515699 517081 517238 517835 525494 526099 529778 539338 540668 544744 545897 551926 554326 554897 559059 559115 561534 563164 579382 581854 588403 599732 599735 603342 603378 614382 618410 624865 643071 664956 665195 667684 724290 738310 738314 738324 739174 743767 745444 760176 781978 788721 794785 812526 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (7.27%) |
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 738310 739174 738314 745444 724290 743767 409945 70131 191343 398551 467239 469360 485210 448619 451606 452185 474393 454408 472650 603342 387951 472696 233179 466823 474876 391980 411723 429239 398560 411769 500938 529778 467095 385528 382993 388333 391427 398231 444117 450183 466903 455872 503801 499274 554326 581854 588403 393245 477645 450122 475298 517238 385826 385991 390851 396865 398567 488311 510925 540668 526099 507691 551926 545897 579382 664956 665195 667684 643071 599732 599735 781978 788721 812526 760176 738324 794785 398564 385386 390150 491109 411628 443681 515699 563164 517081 559115 386576 188240 311007 369353 411631 411794 450156 459764 466789 480490 525494 539338 517835 502028 506846 500905 508162 514885 515074 462104 466983 467032 469387 477208 544744 561534 554897 559059 624865 603378 614382 618410 407790 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.73%) |
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 70131 188240 191343 233179 311007 369353 382993 385386 385528 385826 385991 386576 387951 388333 390150 390851 391427 391980 393245 396865 398231 398551 398560 398564 398567 407790 409945 411628 411631 411723 411769 411794 429239 443681 444117 448619 450122 450156 450183 451606 452185 454408 455872 459764 462104 466789 466823 466903 466983 467032 467095 467239 469360 469387 472650 472696 474393 474876 475298 477208 477645 480490 485210 488311 491109 499274 500905 500938 502028 503801 506846 507691 508162 510925 514885 515074 515699 517081 517238 517835 525494 526099 529778 539338 540668 544744 545897 551926 554326 554897 559059 559115 561534 563164 579382 581854 588403 599732 599735 603342 603378 614382 618410 624865 643071 664956 665195 667684 724290 738310 738314 738324 739174 743767 745444 760176 781978 788721 794785 812526 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"старухи в порн"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бабушк в порн"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.