Query Metrics
7
Database Queries
7
Different statements
150.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.28 ms (81.69%) |
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 34394 187252 191511 194309 199188 259942 377287 383567 387436 389697 391156 400807 411572 450165 453100 454225 454267 455005 455910 458126 459830 459919 461016 462130 462315 463803 463825 466077 466997 467036 467039 467043 471589 474874 475080 475294 476257 476260 480480 480745 483355 483368 485458 485727 485733 485752 486816 487933 498217 498300 498722 504823 510813 511424 513785 514823 516053 518730 518774 518864 518869 519143 519151 522594 524887 525138 525492 525511 529323 530555 533459 537942 549245 549583 550636 558299 563779 565931 567427 577662 588519 589575 605076 607132 612987 667486 678778 678790 678791 678804 693308 696317 698765 705887 710264 713941 719900 732959 733471 733481 734113 736000 738305 738339 738343 744345 745336 758762 770898 772875 773884 775972 779593 781965 789207 794750 802326 810775 811094 812521 ] |
||||||||||||||||||||||||||||||
|
17.43 ms (11.55%) |
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 525138 483368 474874 504823 537942 475294 525511 483355 463803 475080 476257 485458 485727 463825 471589 450165 467039 476260 485733 529323 498300 518774 459919 466997 549583 667486 565931 567427 589575 607132 810775 480480 519151 485752 513785 518730 519143 487933 518864 518869 462315 467043 732959 383567 772875 736000 734113 775972 455910 461016 510813 524887 522594 525492 678791 453100 400807 466077 454225 454267 516053 678804 693308 705887 612987 738305 745336 387436 259942 34394 713941 811094 744345 794750 812521 733471 738343 779593 187252 389697 486816 455005 467036 480745 549245 678778 678790 391156 498722 459830 514823 199188 550636 194309 411572 462130 511424 533459 498217 588519 458126 191511 530555 558299 563779 710264 696317 698765 577662 789207 770898 773884 758762 733481 738339 605076 719900 781965 802326 377287 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.06%) |
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 34394 187252 191511 194309 199188 259942 377287 383567 387436 389697 391156 400807 411572 450165 453100 454225 454267 455005 455910 458126 459830 459919 461016 462130 462315 463803 463825 466077 466997 467036 467039 467043 471589 474874 475080 475294 476257 476260 480480 480745 483355 483368 485458 485727 485733 485752 486816 487933 498217 498300 498722 504823 510813 511424 513785 514823 516053 518730 518774 518864 518869 519143 519151 522594 524887 525138 525492 525511 529323 530555 533459 537942 549245 549583 550636 558299 563779 565931 567427 577662 588519 589575 605076 607132 612987 667486 678778 678790 678791 678804 693308 696317 698765 705887 710264 713941 719900 732959 733471 733481 734113 736000 738305 738339 738343 744345 745336 758762 770898 772875 773884 775972 779593 781965 789207 794750 802326 810775 811094 812521 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"старухи в порн"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бабушк в порн"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.98%) |
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.