Query Metrics
7
Database Queries
7
Different statements
165.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.97 ms (80.85%) |
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 4048 30680 83312 151163 384754 384780 395223 400677 401559 413534 418860 419132 420464 424755 425249 425385 426654 438317 448273 449643 453341 454756 455278 457862 458127 458658 459092 460151 461367 465263 465692 469170 469172 469651 470086 470828 476553 480304 480674 480916 480919 480922 481134 481711 482367 486561 486565 486567 487747 490270 492278 492468 492477 492501 492711 495130 497284 497545 498234 503944 504610 504620 505812 509537 510675 518299 521825 522615 523510 524387 528620 529441 532246 534345 535169 542108 546476 549541 555569 555907 557349 558957 561242 563457 565439 576197 577607 584274 585776 598757 602774 609591 611414 640663 640822 650299 654984 659482 660090 661492 662583 672302 699151 713692 718530 720849 721275 725377 725394 754878 764944 770373 779848 781184 781393 783729 790046 791971 798907 798940 ] |
||||||||||||||||||||||||||||||
|
22.54 ms (13.60%) |
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 779848 783729 534345 659482 419132 609591 453341 654984 584274 791971 798907 549541 458658 426654 504610 458127 151163 505812 577607 30680 400677 660090 509537 561242 83312 518299 480922 465263 495130 497545 457862 460151 480674 455278 459092 481711 470086 764944 522615 492278 585776 754878 425249 497284 469172 504620 546476 449643 470828 523510 469170 492468 461367 529441 598757 486565 420464 521825 555569 465692 480304 492477 490270 486561 454756 448273 528620 565439 401559 542108 602774 469651 498234 476553 524387 510675 503944 480919 486567 487747 413534 492711 424755 418860 480916 482367 481134 532246 718530 4048 384754 798940 557349 721275 555907 650299 492501 425385 662583 384780 770373 535169 611414 781184 725377 781393 672302 699151 725394 576197 395223 640663 720849 661492 640822 438317 790046 563457 713692 558957 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.79%) |
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 4048 30680 83312 151163 384754 384780 395223 400677 401559 413534 418860 419132 420464 424755 425249 425385 426654 438317 448273 449643 453341 454756 455278 457862 458127 458658 459092 460151 461367 465263 465692 469170 469172 469651 470086 470828 476553 480304 480674 480916 480919 480922 481134 481711 482367 486561 486565 486567 487747 490270 492278 492468 492477 492501 492711 495130 497284 497545 498234 503944 504610 504620 505812 509537 510675 518299 521825 522615 523510 524387 528620 529441 532246 534345 535169 542108 546476 549541 555569 555907 557349 558957 561242 563457 565439 576197 577607 584274 585776 598757 602774 609591 611414 640663 640822 650299 654984 659482 660090 661492 662583 672302 699151 713692 718530 720849 721275 725377 725394 754878 764944 770373 779848 781184 781393 783729 790046 791971 798907 798940 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оральный секс в машин%…"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"оральн секс вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.72%) |
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.