Query Metrics
7
Database Queries
7
Different statements
202.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.63 ms (85.10%) |
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 393798 398683 409822 414220 417560 418134 420450 420829 423544 424562 427623 428685 444109 444848 445724 445757 449238 449295 449327 451282 452697 462612 482590 495640 500081 512366 514210 530855 535089 535189 536369 550438 551602 556949 564369 564461 565846 577963 579460 583655 587125 590415 590459 596230 611314 619448 621498 638775 643984 646437 650489 651874 674233 674547 677061 677322 684360 697558 702639 719108 724441 724725 727473 728192 730420 734351 742983 744163 744834 745361 746304 747799 748990 755608 757519 761883 765897 766043 767469 768105 768249 770765 771426 775653 777133 779237 779918 780326 781932 784357 786121 786882 790367 792258 793246 793301 794182 795104 795374 799206 802368 807513 812271 812306 816774 817229 819548 821541 824145 824208 824402 825189 825258 825898 826347 826724 827269 827271 827711 ] |
||||||||||||||||||||||||||||||
|
20.34 ms (10.03%) |
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 451282 418134 414220 827269 590459 786882 719108 793301 744163 730420 420450 427623 445724 530855 495640 684360 677061 611314 779237 799206 462612 423544 824145 825258 827271 827711 819548 550438 702639 651874 674547 619448 596230 775653 780326 793246 795374 779918 792258 812271 724725 746304 748990 770765 784357 724441 744834 757519 747799 767469 768105 771426 802368 825898 449327 564461 428685 514210 482590 587125 452697 579460 417560 449238 826724 816774 734351 745361 577963 825189 825511 826347 646437 727473 768249 393798 444109 444848 449295 536369 535089 564369 583655 650489 677322 565846 643984 807513 424562 445757 409822 500081 512366 674233 398683 420829 821541 817229 824208 824402 535189 551602 556949 621498 638775 590415 777133 781932 812306 786121 795104 755608 790367 794182 728192 742983 766043 761883 765897 697558 ] |
||||||||||||||||||||||||||||||
|
2.74 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 393798 398683 409822 414220 417560 418134 420450 420829 423544 424562 427623 428685 444109 444848 445724 445757 449238 449295 449327 451282 452697 462612 482590 495640 500081 512366 514210 530855 535089 535189 536369 550438 551602 556949 564369 564461 565846 577963 579460 583655 587125 590415 590459 596230 611314 619448 621498 638775 643984 646437 650489 651874 674233 674547 677061 677322 684360 697558 702639 719108 724441 724725 727473 728192 730420 734351 742983 744163 744834 745361 746304 747799 748990 755608 757519 761883 765897 766043 767469 768105 768249 770765 771426 775653 777133 779237 779918 780326 781932 784357 786121 786882 790367 792258 793246 793301 794182 795104 795374 799206 802368 807513 812271 812306 816774 817229 819548 821541 824145 824208 824402 825189 825258 825898 826347 826724 827269 827271 827711 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaved pussy lick"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бритая pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бритая pussy лиза"
]
|
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.