Query Metrics
7
Database Queries
7
Different statements
191.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.78 ms (85.18%) |
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 401936 411445 411789 413971 418013 418423 418879 422512 422832 423245 426062 428315 429759 439845 439927 440654 440680 441017 448724 463096 469023 473184 476137 476430 480197 491938 492221 492575 496269 498012 499178 501732 508133 510588 514218 514709 514820 515433 516350 516584 517365 519530 520954 523958 525686 527738 527975 530384 532251 539192 540912 540914 551275 552273 553061 553706 556320 557449 557985 558337 559161 559454 560202 560212 561136 561321 561862 562202 562494 564564 567453 568604 569088 569692 570233 570252 570604 576379 577699 583132 585144 585630 586472 586573 590992 591788 593656 596505 597227 597232 598464 599610 601491 601630 603076 604608 606695 620612 627809 627813 632979 634777 637086 640055 648871 651877 653213 654566 654617 655087 655320 655631 655996 656789 659674 676025 680116 680182 712879 810109 ] |
||||||||||||||||||||||||||||||
|
18.52 ms (9.69%) |
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 401936 422832 440654 441017 476430 517365 540914 492575 498012 501732 519530 491938 523958 525686 527738 540912 601630 423245 440680 411789 463096 499178 514709 539192 551275 553706 559161 557449 583132 553061 556320 559454 561862 567453 569692 655631 659674 712879 653213 654566 676025 648871 655996 564564 570604 576379 596505 597227 604608 585630 586472 593656 620612 627813 640055 418013 448724 476137 418423 418879 429759 413971 426062 515433 514218 439927 585144 469023 530384 508133 562494 570233 560202 562202 568604 655087 655320 656789 680116 552273 560212 561136 577699 598464 606695 627809 590992 597232 632979 439845 480197 510588 516350 492221 496269 428315 422512 527975 514820 569088 558337 561321 570252 651877 680182 654617 601491 599610 637086 586573 591788 603076 810109 634777 473184 411445 516584 532251 520954 557985 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.60%) |
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 401936 411445 411789 413971 418013 418423 418879 422512 422832 423245 426062 428315 429759 439845 439927 440654 440680 441017 448724 463096 469023 473184 476137 476430 480197 491938 492221 492575 496269 498012 499178 501732 508133 510588 514218 514709 514820 515433 516350 516584 517365 519530 520954 523958 525686 527738 527975 530384 532251 539192 540912 540914 551275 552273 553061 553706 556320 557449 557985 558337 559161 559454 560202 560212 561136 561321 561862 562202 562494 564564 567453 568604 569088 569692 570233 570252 570604 576379 577699 583132 585144 585630 586472 586573 590992 591788 593656 596505 597227 597232 598464 599610 601491 601630 603076 604608 606695 620612 627809 627813 632979 634777 637086 640055 648871 651877 653213 654566 654617 655087 655320 655631 655996 656789 659674 676025 680116 680182 712879 810109 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny babe"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые babe"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые babe"
]
|
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.