Query Metrics
7
Database Queries
7
Different statements
187.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.25 ms (84.58%) |
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 383248 388949 411868 415777 426508 430278 437257 438878 446060 449907 451490 453301 453465 454035 456382 461822 462592 463104 463203 464970 467991 474457 477850 479354 480667 480819 482869 485008 485583 489591 492991 493308 494508 495057 495599 496754 498748 505502 505720 508771 512612 513493 513507 519518 520136 522515 526446 528063 533434 541130 542628 544062 546879 549729 552719 552844 555973 556975 560523 566953 569401 569482 575037 586330 586918 587558 607047 608345 610376 610680 614723 615100 617018 621225 623488 634891 634962 637605 642444 642725 643927 643929 645822 660649 668276 669213 671193 671355 689973 696916 715972 721280 721893 724852 737207 738576 741048 744444 748153 752790 755627 762430 773922 779199 779344 782204 785604 790894 795226 795320 796866 798686 802766 807584 809864 814676 816326 818512 820107 820306 ] |
||||||||||||||||||||||||||||||
|
16.52 ms (8.83%) |
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 779344 744444 738576 607047 480819 495599 485583 513493 426508 430278 782204 802766 809864 453465 533434 542628 569401 480667 449907 621225 513507 508771 544062 546879 634891 454035 456382 526446 560523 669213 715972 643929 623488 519518 748153 762430 485008 566953 773922 388949 489591 512612 411868 642444 586330 446060 451490 437257 495057 383248 755627 820107 660649 721893 807584 737207 643927 795320 463203 461822 816326 814676 569482 668276 608345 637605 586918 779199 796866 724852 741048 617018 785604 492991 463104 479354 541130 552719 795226 752790 522515 520136 552844 671193 689973 615100 610680 610376 634962 798686 721280 505502 575037 498748 474457 464970 528063 438878 415777 494508 496754 549729 645822 462592 467991 482869 820306 818512 477850 505720 493308 671355 696916 642725 587558 614723 790894 555973 453301 556975 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.70%) |
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 383248 388949 411868 415777 426508 430278 437257 438878 446060 449907 451490 453301 453465 454035 456382 461822 462592 463104 463203 464970 467991 474457 477850 479354 480667 480819 482869 485008 485583 489591 492991 493308 494508 495057 495599 496754 498748 505502 505720 508771 512612 513493 513507 519518 520136 522515 526446 528063 533434 541130 542628 544062 546879 549729 552719 552844 555973 556975 560523 566953 569401 569482 575037 586330 586918 587558 607047 608345 610376 610680 614723 615100 617018 621225 623488 634891 634962 637605 642444 642725 643927 643929 645822 660649 668276 669213 671193 671355 689973 696916 715972 721280 721893 724852 737207 738576 741048 744444 748153 752790 755627 762430 773922 779199 779344 782204 785604 790894 795226 795320 796866 798686 802766 807584 809864 814676 816326 818512 820107 820306 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"neighbor большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.29 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"neighbor big tits"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"neighbor большие сиськ"
]
|
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.