Query Metrics
7
Database Queries
7
Different statements
616.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.65 ms (34.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen sexy"
]
|
||||||||||||||||||||||||||||||
|
208.17 ms (33.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen sexy"
]
|
||||||||||||||||||||||||||||||
|
173.58 ms (28.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 282430 287315 388240 390701 390951 395646 403736 410311 412333 418803 418893 420038 420201 429379 429927 429939 431182 432413 432508 433358 435948 438838 443245 443509 447301 447490 447551 448306 448557 449829 451283 451651 452769 452805 454159 454511 454753 457202 459484 459506 460317 460979 460997 461655 462222 462470 464599 464650 464874 465837 466142 467951 472343 475772 483717 484224 495542 505716 519863 519887 520740 524354 524648 524678 525397 528027 529039 529149 534593 539976 543378 550411 558736 561416 565250 572326 572556 572786 579358 584573 586986 590741 594293 595046 595873 597494 598129 598261 598836 600242 602255 614328 617828 618351 622583 626117 626119 633147 639254 642691 671817 675866 677361 677369 680121 682478 684845 709533 719141 733106 744328 747976 748257 777121 788852 791604 799270 810408 811425 814361 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (2.57%) |
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 454753 460979 460997 464599 420038 433358 459484 462222 529149 505716 524354 519863 528027 447490 579358 565250 464650 451651 520740 462470 595873 642691 429927 388240 390701 410311 429379 443509 431182 443245 420201 814361 448557 454511 461655 475772 483717 447301 484224 452805 464874 524648 525397 519887 524678 529039 539976 495542 534593 460317 467951 558736 584573 572786 543378 550411 561416 675866 677369 684845 709533 719141 671817 682478 677361 680121 572326 572556 595046 598261 626117 614328 618351 590741 594293 622583 626119 586986 597494 598129 598836 600242 639254 777121 799270 811425 788852 791604 810408 747976 733106 744328 748257 602255 617828 633147 390951 418803 432413 432508 435948 287315 395646 459506 465837 466142 282430 448306 452769 457202 472343 403736 412333 418893 429939 438838 449829 447551 451283 454159 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.45%) |
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 282430 287315 388240 390701 390951 395646 403736 410311 412333 418803 418893 420038 420201 429379 429927 429939 431182 432413 432508 433358 435948 438838 443245 443509 447301 447490 447551 448306 448557 449829 451283 451651 452769 452805 454159 454511 454753 457202 459484 459506 460317 460979 460997 461655 462222 462470 464599 464650 464874 465837 466142 467951 472343 475772 483717 484224 495542 505716 519863 519887 520740 524354 524648 524678 525397 528027 529039 529149 534593 539976 543378 550411 558736 561416 565250 572326 572556 572786 579358 584573 586986 590741 594293 595046 595873 597494 598129 598261 598836 600242 602255 614328 617828 618351 622583 626117 626119 633147 639254 642691 671817 675866 677361 677369 680121 682478 684845 709533 719141 733106 744328 747976 748257 777121 788852 791604 799270 810408 811425 814361 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen sexy"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.