Query Metrics
7
Database Queries
7
Different statements
225.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.45 ms (85.73%) |
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 390351 394229 401615 408383 410003 410088 414375 420566 422686 423522 437544 439535 452152 454238 455459 458878 458895 466342 466765 468760 469507 469852 471190 472569 474152 475530 480104 480372 480470 480478 481908 481977 485442 486773 489471 490153 491840 498023 498025 498064 501465 503846 506659 507256 512436 515226 515281 515290 515306 515332 515836 516402 518541 519472 519622 519642 519947 521805 524016 524560 525239 531195 531236 533953 534208 534680 542084 548545 548548 548559 548565 548569 548582 548584 552362 553706 553723 555118 557125 557132 558427 560153 560402 560405 560427 560428 560943 562511 563050 563489 564685 572005 572827 581198 584680 586468 586474 593260 593299 593348 593368 593470 593504 593513 593515 593531 593540 593541 598013 598032 599414 610031 615747 641130 667250 669577 684343 691200 745062 809894 ] |
||||||||||||||||||||||||||||||
|
19.91 ms (8.83%) |
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 593260 745062 394229 458878 542084 560402 560427 557132 560405 481908 563050 572827 560153 598013 593531 809894 475530 390351 515306 515836 401615 466765 480478 498023 519947 515332 519642 552362 437544 498064 472569 480470 471190 486773 553723 560943 598032 455459 481977 466342 507256 498025 516402 548565 558427 564685 581198 548559 584680 593540 610031 593504 593513 525239 593515 503846 531195 534208 560428 684343 491840 691200 586468 593368 599414 641130 410003 423522 422686 490153 420566 548584 615747 452152 410088 469507 548569 593541 489471 518541 519622 562511 586474 414375 485442 506659 408383 512436 524016 480104 515281 548582 667250 548545 593299 458895 515290 521805 501465 593348 524560 531236 557125 454238 669577 439535 519472 555118 593470 515226 533953 553706 563489 474152 534680 572005 548548 480372 469852 468760 ] |
||||||||||||||||||||||||||||||
|
4.76 ms (2.11%) |
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 390351 394229 401615 408383 410003 410088 414375 420566 422686 423522 437544 439535 452152 454238 455459 458878 458895 466342 466765 468760 469507 469852 471190 472569 474152 475530 480104 480372 480470 480478 481908 481977 485442 486773 489471 490153 491840 498023 498025 498064 501465 503846 506659 507256 512436 515226 515281 515290 515306 515332 515836 516402 518541 519472 519622 519642 519947 521805 524016 524560 525239 531195 531236 533953 534208 534680 542084 548545 548548 548559 548565 548569 548582 548584 552362 553706 553723 555118 557125 557132 558427 560153 560402 560405 560427 560428 560943 562511 563050 563489 564685 572005 572827 581198 584680 586468 586474 593260 593299 593348 593368 593470 593504 593513 593515 593531 593540 593541 598013 598032 599414 610031 615747 641130 667250 669577 684343 691200 745062 809894 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доктор секс"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"the doctor sex"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.73%) |
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.