Query Metrics
7
Database Queries
7
Different statements
149.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.42 ms (78.35%) |
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 401629 403162 405093 413263 413950 418538 420457 429088 429089 436703 441185 445783 447401 447861 447885 448992 449021 452331 453346 454522 457163 458022 459292 460893 462294 466369 469764 470791 474322 475848 475915 477463 481602 484791 487348 492565 492762 495014 497776 499566 500300 501154 506928 511244 511318 513608 520714 522903 523591 523749 523856 526293 530633 530798 531134 533463 534386 535644 536285 536542 536546 536608 537908 542198 542676 542837 557449 558250 562106 565243 571847 574762 574823 576701 577062 581688 601478 610278 623198 623604 626595 629359 631192 632611 633524 637017 637032 637100 637121 640806 641671 641950 643376 644273 644940 646875 648740 650161 650174 650333 650823 651090 651162 672711 677295 679350 684312 696518 702166 716030 731665 733870 742428 747236 770329 772807 775866 807927 814746 815748 ] |
||||||||||||||||||||||||||||||
|
22.00 ms (14.68%) |
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 513608 403162 447861 526293 475848 646875 640806 633524 405093 470791 484791 650823 641950 441185 445783 511244 500300 536608 814746 581688 574762 436703 429089 747236 458022 453346 454522 474322 475915 534386 696518 462294 506928 644940 815748 574823 631192 807927 558250 533463 448992 460893 499566 641671 413950 562106 557449 637017 536542 531134 542837 742428 413263 650161 650333 481602 522903 497776 520714 651162 684312 731665 623604 523856 420457 477463 648740 651090 775866 772807 770329 452331 457163 523749 542198 643376 623198 429088 565243 576701 650174 644273 610278 466369 469764 447885 495014 536546 511318 530798 677295 672711 632611 401629 523591 536285 537908 637032 679350 716030 459292 626595 702166 577062 542676 492565 535644 601478 487348 571847 637121 637100 733870 629359 447401 449021 492762 418538 501154 530633 ] |
||||||||||||||||||||||||||||||
|
3.09 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 401629 403162 405093 413263 413950 418538 420457 429088 429089 436703 441185 445783 447401 447861 447885 448992 449021 452331 453346 454522 457163 458022 459292 460893 462294 466369 469764 470791 474322 475848 475915 477463 481602 484791 487348 492565 492762 495014 497776 499566 500300 501154 506928 511244 511318 513608 520714 522903 523591 523749 523856 526293 530633 530798 531134 533463 534386 535644 536285 536542 536546 536608 537908 542198 542676 542837 557449 558250 562106 565243 571847 574762 574823 576701 577062 581688 601478 610278 623198 623604 626595 629359 631192 632611 633524 637017 637032 637100 637121 640806 641671 641950 643376 644273 644940 646875 648740 650161 650174 650333 650823 651090 651162 672711 677295 679350 684312 696518 702166 716030 731665 733870 742428 747236 770329 772807 775866 807927 814746 815748 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls big cocks"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк большие cocks"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк большие cocks"
]
|
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.