Query Metrics
7
Database Queries
7
Different statements
166.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.76 ms (83.87%) |
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 413044 414089 414116 414137 415957 416000 416512 416529 416680 416751 417396 418144 419648 424648 427261 430559 431540 432246 432970 439151 439828 439960 440041 443219 444069 444538 445493 446745 446909 447144 447151 448090 448773 448854 450323 450889 452483 452773 452843 455351 456131 458220 459370 465148 466637 466739 468678 470414 471101 473413 477246 477757 478055 478514 482283 482291 483737 483739 486776 486829 488817 489417 493398 495470 495758 497695 497696 498226 500290 504781 505138 505795 508541 508882 508883 511455 518191 519392 519697 519699 524324 528213 542862 545376 545390 545392 545407 545428 545429 546987 557676 558159 561296 567127 569656 578258 579179 579624 581781 583385 590507 595847 598844 602183 609890 613515 614956 614975 616315 619679 625780 628095 640270 660409 722373 725647 752700 789002 806580 ] |
||||||||||||||||||||||||||||||
|
17.46 ms (10.48%) |
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 447144 448090 448854 452843 456131 466739 478514 447151 466637 483737 486776 497689 497695 497696 505138 504781 500290 518191 519697 488817 567127 579179 545407 579624 583385 545392 558159 581781 609890 614956 616315 640270 619679 625780 725647 789002 414089 419648 414137 444538 465148 468678 482283 416680 430559 439151 450323 440041 477246 511455 528213 495470 483739 493398 495758 489417 519699 557676 415957 416000 432970 416512 416751 431540 416529 439828 452773 455351 473413 482291 452483 578258 542862 546987 545429 660409 590507 752700 628095 445493 414116 446909 424648 458220 418144 498226 439960 427261 443219 459370 448773 470414 508882 519392 508883 545376 545390 561296 722373 595847 602183 614975 806580 450889 417396 471101 486829 508541 413044 446745 478055 569656 545428 444069 432246 477757 613515 505795 598844 524324 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.64%) |
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 413044 414089 414116 414137 415957 416000 416512 416529 416680 416751 417396 418144 419648 424648 427261 430559 431540 432246 432970 439151 439828 439960 440041 443219 444069 444538 445493 446745 446909 447144 447151 448090 448773 448854 450323 450889 452483 452773 452843 455351 456131 458220 459370 465148 466637 466739 468678 470414 471101 473413 477246 477757 478055 478514 482283 482291 483737 483739 486776 486829 488817 489417 493398 495470 495758 497695 497696 498226 500290 504781 505138 505795 508541 508882 508883 511455 518191 519392 519697 519699 524324 528213 542862 545376 545390 545392 545407 545428 545429 546987 557676 558159 561296 567127 569656 578258 579179 579624 581781 583385 590507 595847 598844 602183 609890 613515 614956 614975 616315 619679 625780 628095 640270 660409 722373 725647 752700 789002 806580 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер teen огромные"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam teen huge"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер teen огромные"
]
|
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.