Query Metrics
7
Database Queries
7
Different statements
183.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.02 ms (80.12%) |
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 326017 382858 391253 394329 399966 401226 403716 404314 408179 409881 412159 421868 421918 427486 439791 439856 444917 447467 449360 449603 452339 453155 453242 454001 454256 457444 458692 459441 460132 460258 463790 466288 466961 468890 469814 470772 472142 473913 475269 479027 482029 490001 490454 496410 498939 498984 499323 500046 500118 502600 507647 512168 512215 512257 513032 513755 514681 517761 518016 518158 519123 519151 519589 522113 522326 523729 523850 525282 526176 527115 527709 527731 529160 535433 537022 544576 544834 552493 557322 559067 559960 561830 566109 566128 567431 572927 574375 574433 581901 586398 586886 590989 591048 591067 591450 593073 610543 612537 618948 630083 642367 651594 664584 667136 671730 680890 697000 703987 705310 711589 714380 718720 726512 726587 765311 775207 796227 811076 818315 820143 ] |
||||||||||||||||||||||||||||||
|
26.58 ms (14.49%) |
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 566128 559960 590989 726512 726587 473913 326017 399966 468890 482029 525282 498984 586886 453242 460258 500046 552493 574433 593073 470772 519151 523729 490001 382858 404314 454001 466961 452339 459441 500118 517761 537022 460132 469814 557322 574375 566109 667136 703987 711589 651594 664584 680890 671730 705310 718720 610543 591048 591450 618948 642367 612537 775207 796227 765311 811076 427486 447467 409881 403716 522326 512168 519123 522113 527709 820143 453155 475269 502600 514681 496410 513032 518158 526176 714380 544834 586398 630083 457444 439856 479027 458692 439791 444917 490454 523850 499323 527731 449360 697000 391253 408179 518016 527115 561830 572927 544576 567431 581901 591067 421918 401226 449603 498939 529160 513755 818315 512215 421868 507647 512257 466288 559067 463790 472142 454256 535433 519589 412159 394329 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.42%) |
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 326017 382858 391253 394329 399966 401226 403716 404314 408179 409881 412159 421868 421918 427486 439791 439856 444917 447467 449360 449603 452339 453155 453242 454001 454256 457444 458692 459441 460132 460258 463790 466288 466961 468890 469814 470772 472142 473913 475269 479027 482029 490001 490454 496410 498939 498984 499323 500046 500118 502600 507647 512168 512215 512257 513032 513755 514681 517761 518016 518158 519123 519151 519589 522113 522326 523729 523850 525282 526176 527115 527709 527731 529160 535433 537022 544576 544834 552493 557322 559067 559960 561830 566109 566128 567431 572927 574375 574433 581901 586398 586886 590989 591048 591067 591450 593073 610543 612537 618948 630083 642367 651594 664584 667136 671730 680890 697000 703987 705310 711589 714380 718720 726512 726587 765311 775207 796227 811076 818315 820143 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen tits"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.68%) |
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.