Query Metrics
7
Database Queries
7
Different statements
158.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.16 ms (84.40%) |
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 381933 389023 413126 415561 415577 415632 415879 421061 428710 440534 442189 452869 454239 454243 454548 454752 458707 459173 459191 459684 464246 467961 470663 470726 476091 476168 479044 479053 479955 486173 486190 488233 489379 490517 491431 494290 494312 495031 495138 498363 499099 500464 500576 500916 506222 509799 510519 511388 511872 513131 514790 514935 516492 519349 519738 519894 521391 522447 522673 523933 525233 525848 528913 528942 529704 532166 532170 532266 532364 539047 542529 542730 544768 546716 547622 552992 555055 556009 557438 557521 559087 562398 564121 565008 565018 566002 566059 566074 567400 570959 575329 580388 580623 581306 582235 583142 591277 592891 595101 596234 601444 605588 612068 623822 631478 637048 641414 646872 668804 690831 694534 696430 700134 700284 707368 786120 791209 796877 799591 810698 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (10.04%) |
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 459684 479955 415561 440534 454239 470726 479044 442189 467961 511872 514790 523933 525848 488233 494290 495031 510519 511388 486173 486190 498363 506222 516492 519738 521391 522447 525233 491431 556009 786120 494312 522673 489379 381933 389023 413126 421061 428710 415879 415632 605588 454548 458707 459191 490517 476168 452869 459173 479053 495138 500464 500916 513131 532266 519349 519894 529704 539047 499099 500576 509799 514935 528942 532166 532170 532364 528913 464246 470663 566002 580388 581306 582235 583142 542529 542730 544768 546716 555055 564121 565008 566074 567400 570959 580623 547622 557438 565018 566059 690831 694534 707368 646872 668804 696430 552992 557521 559087 562398 575329 591277 596234 595101 623822 631478 592891 601444 637048 641414 791209 799591 810698 612068 700134 700284 796877 415577 454243 454752 476091 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.65%) |
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 381933 389023 413126 415561 415577 415632 415879 421061 428710 440534 442189 452869 454239 454243 454548 454752 458707 459173 459191 459684 464246 467961 470663 470726 476091 476168 479044 479053 479955 486173 486190 488233 489379 490517 491431 494290 494312 495031 495138 498363 499099 500464 500576 500916 506222 509799 510519 511388 511872 513131 514790 514935 516492 519349 519738 519894 521391 522447 522673 523933 525233 525848 528913 528942 529704 532166 532170 532266 532364 539047 542529 542730 544768 546716 547622 552992 555055 556009 557438 557521 559087 562398 564121 565008 565018 566002 566059 566074 567400 570959 575329 580388 580623 581306 582235 583142 591277 592891 595101 596234 601444 605588 612068 623822 631478 637048 641414 646872 668804 690831 694534 696430 700134 700284 707368 786120 791209 796877 799591 810698 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf video"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf video"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf video"
]
|
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.