Query Metrics
7
Database Queries
7
Different statements
364.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.24 ms (55.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
135.58 ms (37.16%) |
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 96636 97694 388325 388353 395646 395973 404217 414385 416928 417084 417881 418538 425491 429292 429516 438424 442238 445471 447086 448674 448713 452178 456380 463757 463777 464209 465951 468731 470443 474007 474688 475078 475804 475933 475945 477073 477347 477875 478829 479100 480245 484802 489217 490684 490729 490785 491415 491474 492259 492261 497230 500180 502709 507675 508967 509799 513156 513278 513696 515213 516083 516307 516351 516685 516761 516768 519956 521581 522851 523679 526434 527865 535013 535542 536691 537661 550091 559195 559228 560831 573230 576079 576371 576372 581882 585740 600225 603220 620160 620377 622345 623178 632383 632656 636269 640685 642677 644569 645263 650350 650793 653471 665920 678942 732003 734514 750827 790754 793448 805023 809521 815394 815566 816086 817033 821846 821852 822693 827876 827940 ] |
||||||||||||||||||||||||||||||
|
16.33 ms (4.47%) |
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 456380 475945 622345 636269 793448 809521 513278 516768 573230 650350 665920 632656 603220 416928 815394 468731 477875 576371 560831 734514 395646 425491 474007 490729 491474 821852 821846 477073 650793 640685 477347 490684 827940 484802 632383 507675 537661 516307 516083 581882 521581 497230 452178 526434 445471 620377 388353 475078 463757 653471 535013 536691 96636 414385 516761 550091 600225 475933 492261 508967 97694 388325 489217 645263 678942 491415 522851 395973 417084 817033 480245 490785 515213 513696 559195 642677 620160 623178 644569 585740 805023 750827 478829 417881 475804 822693 509799 519956 527865 492259 576372 732003 447086 448674 404217 465951 559228 576079 429516 474688 516685 502709 523679 442238 464209 470443 479100 513156 815566 463777 448713 429292 438424 816086 500180 827876 535542 516351 418538 790754 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.83%) |
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 96636 97694 388325 388353 395646 395973 404217 414385 416928 417084 417881 418538 425491 429292 429516 438424 442238 445471 447086 448674 448713 452178 456380 463757 463777 464209 465951 468731 470443 474007 474688 475078 475804 475933 475945 477073 477347 477875 478829 479100 480245 484802 489217 490684 490729 490785 491415 491474 492259 492261 497230 500180 502709 507675 508967 509799 513156 513278 513696 515213 516083 516307 516351 516685 516761 516768 519956 521581 522851 523679 526434 527865 535013 535542 536691 537661 550091 559195 559228 560831 573230 576079 576371 576372 581882 585740 600225 603220 620160 620377 622345 623178 632383 632656 636269 640685 642677 644569 645263 650350 650793 653471 665920 678942 732003 734514 750827 790754 793448 805023 809521 815394 815566 816086 817033 821846 821852 822693 827876 827940 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm threesome"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.