Query Metrics
7
Database Queries
7
Different statements
156.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.93 ms (84.31%) |
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 400723 403834 416035 420150 422409 423836 423840 425160 425484 432310 437401 440737 441209 443010 443481 444231 444842 448148 448647 451702 452641 453662 455258 456574 462597 463493 468328 471559 476376 477954 479007 479593 480134 488588 488822 490791 494807 495648 495691 496368 496519 497014 499010 504251 504261 505155 507009 507377 508757 510639 514037 514467 514608 518335 519859 519882 520009 522028 523301 533649 535227 538054 548295 548754 549782 551805 552996 553186 553601 560333 560573 561942 565293 566615 566933 567717 568276 569023 571725 574190 574589 577953 578508 579392 579879 580101 585245 585734 589197 591236 594151 595726 599400 604346 604799 608363 614658 625323 625759 628107 634422 643986 658486 667117 685892 689973 698018 729933 738260 744012 766849 768123 777103 787620 787674 793586 795385 798982 807050 809779 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (9.44%) |
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 440737 504251 604346 443010 456574 479007 495691 488822 495648 514037 441209 504261 580101 658486 425160 628107 585734 614658 698018 443481 496519 579392 403834 766849 425484 505155 480134 488588 548754 809779 567717 448647 471559 455258 514467 518335 520009 463493 552996 578508 497014 522028 571725 551805 594151 444842 565293 595726 608363 477954 462597 423836 499010 444231 523301 507377 535227 574190 667117 560333 568276 625759 729933 452641 432310 566615 643986 416035 533649 494807 510639 548295 561942 685892 589197 591236 634422 795385 777103 798982 787674 793586 807050 738260 744012 508757 519882 507009 514608 574589 553601 768123 400723 468328 490791 476376 451702 689973 553186 604799 585245 787620 437401 625323 453662 420150 422409 519859 496368 566933 569023 599400 479593 538054 549782 560573 577953 579879 423840 448148 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.90%) |
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 400723 403834 416035 420150 422409 423836 423840 425160 425484 432310 437401 440737 441209 443010 443481 444231 444842 448148 448647 451702 452641 453662 455258 456574 462597 463493 468328 471559 476376 477954 479007 479593 480134 488588 488822 490791 494807 495648 495691 496368 496519 497014 499010 504251 504261 505155 507009 507377 508757 510639 514037 514467 514608 518335 519859 519882 520009 522028 523301 533649 535227 538054 548295 548754 549782 551805 552996 553186 553601 560333 560573 561942 565293 566615 566933 567717 568276 569023 571725 574190 574589 577953 578508 579392 579879 580101 585245 585734 589197 591236 594151 595726 599400 604346 604799 608363 614658 625323 625759 628107 634422 643986 658486 667117 685892 689973 698018 729933 738260 744012 766849 768123 777103 787620 787674 793586 795385 798982 807050 809779 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam skinny blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер худые минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.