Query Metrics
7
Database Queries
7
Different statements
427.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.98 ms (48.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
196.19 ms (45.89%) |
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 386627 388183 400265 416453 418372 422101 429217 430549 435373 438852 444647 449590 450450 460314 461962 464471 474210 477525 492795 493567 506764 522270 526315 544057 544891 545682 547735 549555 553277 554243 557289 558098 560918 562204 568864 574377 579219 579452 580001 581036 581762 582847 585835 587534 588935 589951 594254 594512 595527 597534 598256 598580 600492 605379 613757 614325 620393 624399 626492 627009 632289 639252 646936 655458 658453 658469 658854 659944 662375 669271 670980 686821 687419 695878 705800 705825 706006 711761 718865 719573 726946 739318 739909 740694 742369 745478 747320 750603 750637 750967 755422 756495 760456 766529 768386 770200 778304 780231 781003 781354 781861 782411 784605 786412 787508 788423 790924 792971 794229 794248 798473 800497 800698 802356 806427 806432 806695 806938 808228 ] |
||||||||||||||||||||||||||||||
|
15.87 ms (3.71%) |
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 574377 544891 545682 547735 549555 553277 557289 558098 560918 554243 562204 568864 579452 580001 582847 655458 658453 662375 669271 670980 705800 706006 686821 646936 658469 658854 659944 687419 695878 579219 605379 585835 587534 594254 595527 598580 639252 589951 620393 624399 626492 600492 780231 781003 794229 798473 806432 808228 781354 781861 784605 786412 800497 739909 740694 750637 760456 766529 770200 788423 790924 806695 806938 750967 756495 760434 726946 745478 739318 747320 750603 755422 613757 627009 632289 705825 711761 718865 719573 782411 787508 792971 794248 800698 802356 806427 418372 444647 464471 388183 422101 450450 400265 429217 449590 461962 474210 526315 522270 386627 416453 430549 492795 493567 477525 506764 581762 581036 544057 614325 594512 598256 588935 597534 778304 768386 742369 438852 435373 460314 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.66%) |
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 386627 388183 400265 416453 418372 422101 429217 430549 435373 438852 444647 449590 450450 460314 461962 464471 474210 477525 492795 493567 506764 522270 526315 544057 544891 545682 547735 549555 553277 554243 557289 558098 560918 562204 568864 574377 579219 579452 580001 581036 581762 582847 585835 587534 588935 589951 594254 594512 595527 597534 598256 598580 600492 605379 613757 614325 620393 624399 626492 627009 632289 639252 646936 655458 658453 658469 658854 659944 662375 669271 670980 686821 687419 695878 705800 705825 706006 711761 718865 719573 726946 739318 739909 740694 742369 745478 747320 750603 750637 750967 755422 756495 760456 766529 768386 770200 778304 780231 781003 781354 781861 782411 784605 786412 787508 788423 790924 792971 794229 794248 798473 800497 800698 802356 806427 806432 806695 806938 808228 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"herself мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"herself masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"herself мастурбац"
]
|
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.