Query Metrics
7
Database Queries
7
Different statements
179.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.56 ms (85.02%) |
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 384917 388363 388545 389202 389495 390389 391150 401184 401215 401684 414277 415863 416620 419970 420434 420534 424606 428932 429108 434900 438770 442645 442650 443519 444005 444647 446008 446497 447040 447762 447775 448579 448582 451598 452427 452903 452948 453208 453223 453820 454083 454744 457216 457992 459195 459252 465680 466306 469054 469139 470061 471077 471116 471121 471163 476063 477507 480203 480232 480494 480541 483494 484910 485905 488789 492834 494806 495489 495490 495547 496812 502789 510906 512810 519646 527829 529001 529149 529902 530121 530942 535916 536659 537780 538716 541478 546972 548465 548474 550032 552094 553194 553285 553517 554372 556788 557360 564641 567083 567888 568214 570956 574706 580220 580230 584046 598469 598809 600125 602993 603491 619085 650280 654048 681766 700257 744774 758648 803036 803047 ] |
||||||||||||||||||||||||||||||
|
17.30 ms (9.64%) |
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 428932 447762 390389 469139 454083 527829 529001 519646 452427 480494 384917 388545 388363 401215 401684 442645 442650 446008 453223 471121 452903 452948 453820 480232 480541 488789 457216 457992 477507 502789 510906 537780 494806 495490 529902 535916 495489 541478 548474 552094 556788 567083 546972 557360 568214 574706 580230 554372 580220 654048 700257 650280 681766 548465 553194 553285 598809 600125 598469 619085 602993 758648 803036 803047 744774 603491 414277 438770 443519 448579 389495 401184 416620 434900 444647 459252 465680 466306 444005 447775 454744 480203 389202 429108 448582 471163 536659 483494 492834 496812 512810 529149 485905 495547 391150 415863 424606 419970 420534 420434 446497 447040 469054 471116 476063 484910 459195 470061 451598 453208 471077 530121 530942 538716 567888 584046 550032 553517 564641 570956 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.57%) |
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 384917 388363 388545 389202 389495 390389 391150 401184 401215 401684 414277 415863 416620 419970 420434 420534 424606 428932 429108 434900 438770 442645 442650 443519 444005 444647 446008 446497 447040 447762 447775 448579 448582 451598 452427 452903 452948 453208 453223 453820 454083 454744 457216 457992 459195 459252 465680 466306 469054 469139 470061 471077 471116 471121 471163 476063 477507 480203 480232 480494 480541 483494 484910 485905 488789 492834 494806 495489 495490 495547 496812 502789 510906 512810 519646 527829 529001 529149 529902 530121 530942 535916 536659 537780 538716 541478 546972 548465 548474 550032 552094 553194 553285 553517 554372 556788 557360 564641 567083 567888 568214 570956 574706 580220 580230 584046 598469 598809 600125 602993 603491 619085 650280 654048 681766 700257 744774 758648 803036 803047 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cam solo"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cam соло"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cam соло"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.