Query Metrics
7
Database Queries
7
Different statements
380.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
354.68 ms (93.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 7108 32874 33260 161318 382898 383290 387160 396410 401517 402869 403293 407562 414088 415739 417495 417825 417865 428767 430549 432571 448705 458202 461738 463838 464344 465483 465484 467639 468371 468476 472263 476441 479858 495321 496279 497806 499717 517181 519182 520186 525678 528173 533559 539917 543035 569160 578208 582741 583948 587081 593394 601710 604515 604571 613015 618036 621967 635236 638533 638988 642377 646022 647641 678816 680096 683052 686034 690884 693220 694100 705702 710266 715833 720119 722187 722489 722833 725451 726165 729160 729181 732468 737554 740616 741308 742439 744656 747355 748195 754923 755387 757480 762899 777011 783935 785679 788729 789497 790021 792587 792591 793243 795413 795859 797410 800474 802432 807621 810449 811103 811727 812501 813799 814661 818281 821162 822189 822559 824900 828758 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (4.09%) |
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 569160 678816 642377 783935 812501 754923 789497 793243 762899 811727 726165 382898 461738 539917 543035 705702 722489 635236 638988 777011 792587 740616 742439 497806 646022 472263 463838 525678 800474 725451 795413 811103 528173 686034 722833 680096 683052 720119 694100 621967 795859 788729 792591 757480 729160 744656 747355 790021 161318 415739 465483 690884 710266 732468 821162 813799 824900 517181 519182 464344 802432 810449 755387 533559 383290 715833 499717 601710 578208 647641 604571 613015 638533 604515 729181 430549 468476 520186 432571 403293 417825 458202 33260 401517 417865 407562 465484 583948 587081 417495 32874 7108 414088 822189 822559 814661 818281 828758 496279 693220 722187 785679 737554 748195 797410 387160 479858 582741 593394 468371 618036 807621 495321 402869 428767 396410 467639 741308 448705 476441 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (0.77%) |
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 7108 32874 33260 161318 382898 383290 387160 396410 401517 402869 403293 407562 414088 415739 417495 417825 417865 428767 430549 432571 448705 458202 461738 463838 464344 465483 465484 467639 468371 468476 472263 476441 479858 495321 496279 497806 499717 517181 519182 520186 525678 528173 533559 539917 543035 569160 578208 582741 583948 587081 593394 601710 604515 604571 613015 618036 621967 635236 638533 638988 642377 646022 647641 678816 680096 683052 686034 690884 693220 694100 705702 710266 715833 720119 722187 722489 722833 725451 726165 729160 729181 732468 737554 740616 741308 742439 744656 747355 748195 754923 755387 757480 762899 777011 783935 785679 788729 789497 790021 792587 792591 793243 795413 795859 797410 800474 802432 807621 810449 811103 811727 812501 813799 814661 818281 821162 822189 822559 824900 828758 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits black"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ black"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ black"
]
|
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.