Query Metrics
7
Database Queries
7
Different statements
185.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.29 ms (84.98%) |
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 385344 388726 401032 411736 411761 413641 414364 419654 419773 423518 425168 426511 432831 440906 444820 448863 454284 455085 461765 462342 465604 466063 466838 470064 470500 471000 471122 471881 472120 473944 474654 477943 478782 478784 484678 486862 493587 495562 495752 497905 502540 502775 503934 510876 515089 518585 520775 522891 527871 531195 533013 534999 536580 537195 537886 541110 542508 543497 545389 545505 550305 550327 571146 571230 576355 576650 585011 585013 585698 592444 603671 603682 610284 611346 628315 628394 632333 632684 632688 633524 633766 634771 637033 637048 637438 637680 638552 640525 644689 645020 646782 648238 648685 650817 652915 656507 656577 666907 672175 677703 678942 679761 679808 680111 680153 681031 681587 683529 707280 711291 712964 715128 719104 745493 746995 755850 756390 773833 775752 815490 ] |
||||||||||||||||||||||||||||||
|
18.79 ms (10.15%) |
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 633766 455085 426511 466063 484678 474654 470064 486862 510876 515089 536580 652915 592444 411736 440906 413641 815490 518585 531195 493587 571230 541110 680111 666907 650817 628315 603682 637438 603671 628394 632333 632688 633524 423518 444820 473944 401032 522891 527871 495562 425168 495752 520775 503934 533013 576650 545389 432831 419773 466838 477943 648685 745493 462342 461765 388726 411761 419654 414364 585013 585011 465604 472120 470500 454284 537195 497905 534999 537886 543497 545505 542508 550305 646782 656507 672175 681031 683529 707280 715128 719104 678942 681587 712964 645020 648238 656577 677703 679761 679808 680153 550327 571146 576355 637680 610284 632684 637033 640525 644689 637048 638552 775752 756390 746995 755850 773833 611346 634771 711291 385344 471122 471000 478782 478784 502775 448863 585698 502540 471881 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.56%) |
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 385344 388726 401032 411736 411761 413641 414364 419654 419773 423518 425168 426511 432831 440906 444820 448863 454284 455085 461765 462342 465604 466063 466838 470064 470500 471000 471122 471881 472120 473944 474654 477943 478782 478784 484678 486862 493587 495562 495752 497905 502540 502775 503934 510876 515089 518585 520775 522891 527871 531195 533013 534999 536580 537195 537886 541110 542508 543497 545389 545505 550305 550327 571146 571230 576355 576650 585011 585013 585698 592444 603671 603682 610284 611346 628315 628394 632333 632684 632688 633524 633766 634771 637033 637048 637438 637680 638552 640525 644689 645020 646782 648238 648685 650817 652915 656507 656577 666907 672175 677703 678942 679761 679808 680111 680153 681031 681587 683529 707280 711291 712964 715128 719104 745493 746995 755850 756390 773833 775752 815490 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон double"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits double"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон double"
]
|
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.