Query Metrics
7
Database Queries
7
Different statements
169.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.37 ms (83.32%) |
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 395550 419612 432730 432734 446264 446502 447971 454310 454669 454706 455798 455799 455804 455805 455807 456857 457708 457729 457750 457784 457792 459171 459177 459605 462299 462950 465012 465991 467137 469227 469233 469238 469242 469244 469245 471174 471196 471777 472129 472134 476469 478911 478947 480894 483452 483754 483812 487650 487657 488236 488885 489648 489780 489793 490141 490242 491172 492939 494459 494666 495901 498827 499270 503071 507166 509022 510717 511283 513243 517371 518782 519818 521168 523412 523753 524503 524618 526227 526539 527281 530548 534363 535697 535703 535711 537290 540229 543575 547986 550052 552278 553448 559087 560538 565220 566091 566619 568096 571828 572869 573375 578060 578066 578068 579764 585744 589767 590499 591287 598097 599772 610721 617784 618230 635697 666823 673121 708274 721967 814049 ] |
||||||||||||||||||||||||||||||
|
17.51 ms (10.32%) |
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 488885 565220 446264 524618 566091 471174 495901 457729 487657 455805 459605 503071 560538 454669 494459 507166 454310 469238 472134 456857 568096 599772 471777 550052 462299 487650 457792 455798 472129 510717 469245 488236 469233 578060 395550 509022 535697 491172 465991 455799 455807 535703 469227 517371 590499 530548 610721 708274 673121 635697 499270 469242 537290 519818 543575 478947 446502 591287 540229 526227 454706 534363 578068 489648 478911 457708 559087 566619 480894 483754 494666 489793 498827 492939 490242 490141 469244 666823 465012 518782 578066 814049 521168 721967 547986 447971 459177 571828 462950 527281 471196 552278 476469 455804 483812 489780 579764 523412 457750 457784 513243 483452 467137 511283 524503 589767 523753 553448 572869 617784 598097 526539 618230 585744 535711 459171 573375 432734 419612 432730 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.55%) |
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 395550 419612 432730 432734 446264 446502 447971 454310 454669 454706 455798 455799 455804 455805 455807 456857 457708 457729 457750 457784 457792 459171 459177 459605 462299 462950 465012 465991 467137 469227 469233 469238 469242 469244 469245 471174 471196 471777 472129 472134 476469 478911 478947 480894 483452 483754 483812 487650 487657 488236 488885 489648 489780 489793 490141 490242 491172 492939 494459 494666 495901 498827 499270 503071 507166 509022 510717 511283 513243 517371 518782 519818 521168 523412 523753 524503 524618 526227 526539 527281 530548 534363 535697 535703 535711 537290 540229 543575 547986 550052 552278 553448 559087 560538 565220 566091 566619 568096 571828 572869 573375 578060 578066 578068 579764 585744 589767 590499 591287 598097 599772 610721 617784 618230 635697 666823 673121 708274 721967 814049 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden public sex"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
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.