Query Metrics
7
Database Queries
7
Different statements
166.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.08 ms (86.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 357457 397478 397775 398500 403871 409454 411549 418123 418372 434293 434307 434344 434382 435395 437970 438178 441556 442337 449992 452341 452730 452764 452899 452903 455134 456161 459155 466028 476668 477244 477249 478023 489324 500320 502780 505325 506688 507032 508254 509762 511374 515435 519351 529933 530862 540868 543993 547762 547783 555245 568757 577023 579582 581392 587291 593994 596240 619802 630270 634381 639113 640393 643005 662165 696499 708062 724923 731404 734860 736038 741119 746194 751006 752773 752780 769445 772510 778150 779868 781250 782096 782821 783920 784411 784456 784626 785087 786711 787528 787812 790463 793940 794030 794038 795380 795395 795406 796071 796997 797032 798287 801818 806421 806933 806937 806991 806994 808327 808652 810461 810904 811221 812385 814446 814455 818686 819424 821198 824870 826234 ] |
||||||||||||||||||||||||||||||
|
14.04 ms (8.41%) |
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 784411 724923 731404 357457 403871 818686 507032 530862 555245 781250 810461 806933 812385 793940 794038 411549 438178 826234 442337 741119 397478 502780 397775 801818 441556 662165 787528 806421 786711 434382 455134 529933 778150 505325 587291 506688 593994 814446 452730 543993 630270 796071 806937 806994 798287 810904 596240 643005 808327 547762 577023 581392 783920 500320 752773 476668 452764 511374 449992 398500 784626 794030 808652 811221 795395 736038 785087 437970 434293 434307 418372 821198 639113 746194 769445 795380 515435 579582 790463 806991 784456 772510 787812 435395 452903 489324 782096 418123 477249 508254 540868 814455 452341 568757 751006 452899 459155 409454 434344 456161 509762 547783 795406 466028 519351 819424 634381 640393 734860 619802 796997 696499 797032 752780 824870 477244 478023 708062 779868 782821 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.35%) |
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 357457 397478 397775 398500 403871 409454 411549 418123 418372 434293 434307 434344 434382 435395 437970 438178 441556 442337 449992 452341 452730 452764 452899 452903 455134 456161 459155 466028 476668 477244 477249 478023 489324 500320 502780 505325 506688 507032 508254 509762 511374 515435 519351 529933 530862 540868 543993 547762 547783 555245 568757 577023 579582 581392 587291 593994 596240 619802 630270 634381 639113 640393 643005 662165 696499 708062 724923 731404 734860 736038 741119 746194 751006 752773 752780 769445 772510 778150 779868 781250 782096 782821 783920 784411 784456 784626 785087 786711 787528 787812 790463 793940 794030 794038 795380 795395 795406 796071 796997 797032 798287 801818 806421 806933 806937 806991 806994 808327 808652 810461 810904 811221 812385 814446 814455 818686 819424 821198 824870 826234 ] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl squirt solo"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк сквирт оргазм соло"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.72%) |
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.