Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "teen sex massage"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen sex massage' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  595854
  620044
  600489
  387328
  503122
  494148
  596412
  584172
  573391
  722871
  610694
  717860
  600453
  410615
  628044
  596423
  568349
  452107
  770271
  595507
  607626
  828849
  411787
  619592
  556374
  821534
  625980
  511249
  409907
  757061
  584339
  723072
  466124
  565947
  552193
  776234
  395249
  459229
  630825
  732443
  494396
  535422
  513655
  464107
  489577
  769890
  527215
  532255
  424932
  489650
  403928
  413273
  430814
  552603
  588647
  492029
  662556
  456291
  404772
  415188
  448846
  525019
  527267
  655838
  389563
  528921
  489691
  766625
  525349
  559389
  558543
  621087
  443112
  525276
  624847
  518511
  418686
  631957
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (595854, 620044, 600489, 387328, 503122, 494148, 596412, 584172, 573391, 722871, 610694, 717860, 600453, 410615, 628044, 596423, 568349, 452107, 770271, 595507, 607626, 828849, 411787, 619592, 556374, 821534, 625980, 511249, 409907, 757061, 584339, 723072, 466124, 565947, 552193, 776234, 395249, 459229, 630825, 732443, 494396, 535422, 513655, 464107, 489577, 769890, 527215, 532255, 424932, 489650, 403928, 413273, 430814, 552603, 588647, 492029, 662556, 456291, 404772, 415188, 448846, 525019, 527267, 655838, 389563, 528921, 489691, 766625, 525349, 559389, 558543, 621087, 443112, 525276, 624847, 518511, 418686, 631957);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  387328
  389563
  395249
  403928
  404772
  409907
  410615
  411787
  413273
  415188
  418686
  424932
  430814
  443112
  448846
  452107
  456291
  459229
  464107
  466124
  489577
  489650
  489691
  492029
  494148
  494396
  503122
  511249
  513655
  518511
  525019
  525276
  525349
  527215
  527267
  528921
  532255
  535422
  552193
  552603
  556374
  558543
  559389
  565947
  568349
  573391
  584172
  584339
  588647
  595507
  595854
  596412
  596423
  600453
  600489
  607626
  610694
  619592
  620044
  621087
  624847
  625980
  628044
  630825
  631957
  655838
  662556
  717860
  722871
  723072
  732443
  757061
  766625
  769890
  770271
  776234
  821534
  828849
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (387328, 389563, 395249, 403928, 404772, 409907, 410615, 411787, 413273, 415188, 418686, 424932, 430814, 443112, 448846, 452107, 456291, 459229, 464107, 466124, 489577, 489650, 489691, 492029, 494148, 494396, 503122, 511249, 513655, 518511, 525019, 525276, 525349, 527215, 527267, 528921, 532255, 535422, 552193, 552603, 556374, 558543, 559389, 565947, 568349, 573391, 584172, 584339, 588647, 595507, 595854, 596412, 596423, 600453, 600489, 607626, 610694, 619592, 620044, 621087, 624847, 625980, 628044, 630825, 631957, 655838, 662556, 717860, 722871, 723072, 732443, 757061, 766625, 769890, 770271, 776234, 821534, 828849);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  387328
  389563
  395249
  403928
  404772
  409907
  410615
  411787
  413273
  415188
  418686
  424932
  430814
  443112
  448846
  452107
  456291
  459229
  464107
  466124
  489577
  489650
  489691
  492029
  494148
  494396
  503122
  511249
  513655
  518511
  525019
  525276
  525349
  527215
  527267
  528921
  532255
  535422
  552193
  552603
  556374
  558543
  559389
  565947
  568349
  573391
  584172
  584339
  588647
  595507
  595854
  596412
  596423
  600453
  600489
  607626
  610694
  619592
  620044
  621087
  624847
  625980
  628044
  630825
  631957
  655838
  662556
  717860
  722871
  723072
  732443
  757061
  766625
  769890
  770271
  776234
  821534
  828849
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (387328, 389563, 395249, 403928, 404772, 409907, 410615, 411787, 413273, 415188, 418686, 424932, 430814, 443112, 448846, 452107, 456291, 459229, 464107, 466124, 489577, 489650, 489691, 492029, 494148, 494396, 503122, 511249, 513655, 518511, 525019, 525276, 525349, 527215, 527267, 528921, 532255, 535422, 552193, 552603, 556374, 558543, 559389, 565947, 568349, 573391, 584172, 584339, 588647, 595507, 595854, 596412, 596423, 600453, 600489, 607626, 610694, 619592, 620044, 621087, 624847, 625980, 628044, 630825, 631957, 655838, 662556, 717860, 722871, 723072, 732443, 757061, 766625, 769890, 770271, 776234, 821534, 828849);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "teen секс массаж"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen секс массаж';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "teen секс массаж"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen секс массаж';