6.54 ms (15.78%)
|
2 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.retail AS retail_3, p0_.distributor AS distributor_4, p0_.cnpj AS cnpj_5, p0_.static_map AS static_map_6, p0_.address AS address_7, p0_.number AS number_8, p0_.zip_code AS zip_code_9, p0_.neighborhood AS neighborhood_10, p0_.city AS city_11, p0_.state AS state_12, p0_.country AS country_13, p0_.lat AS lat_14, p0_.lng AS lng_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.active AS active_18, p0_.client_id AS client_id_19 FROM pdv p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"1"
"4"
"5"
"6"
"7"
"8"
"9"
"10"
"11"
"12"
"13"
"14"
"15"
"16"
"17"
"18"
"19"
"20"
"21"
"22"
"23"
"24"
"25"
"26"
"27"
"28"
"29"
"30"
"31"
"32"
"33"
"34"
"35"
"36"
"37"
"38"
"39"
"40"
"41"
"42"
"43"
"44"
"45"
"46"
"47"
"48"
"49"
"50"
"51"
"52"
"53"
"54"
"55"
"56"
"57"
"58"
"59"
"60"
"61"
"62"
"63"
"64"
"65"
"66"
"67"
"68"
"69"
"70"
"71"
"72"
]
SELECT
p0_.id AS id_0,
p0_.name AS name_1,
p0_.type AS type_2,
p0_.retail AS retail_3,
p0_.distributor AS distributor_4,
p0_.cnpj AS cnpj_5,
p0_.static_map AS static_map_6,
p0_.address AS address_7,
p0_.number AS number_8,
p0_.zip_code AS zip_code_9,
p0_.neighborhood AS neighborhood_10,
p0_.city AS city_11,
p0_.state AS state_12,
p0_.country AS country_13,
p0_.lat AS lat_14,
p0_.lng AS lng_15,
p0_.created_at AS created_at_16,
p0_.updated_at AS updated_at_17,
p0_.active AS active_18,
p0_.client_id AS client_id_19
FROM
pdv p0_
WHERE
p0_.id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?
)
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.retail AS retail_3, p0_.distributor AS distributor_4, p0_.cnpj AS cnpj_5, p0_.static_map AS static_map_6, p0_.address AS address_7, p0_.number AS number_8, p0_.zip_code AS zip_code_9, p0_.neighborhood AS neighborhood_10, p0_.city AS city_11, p0_.state AS state_12, p0_.country AS country_13, p0_.lat AS lat_14, p0_.lng AS lng_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.active AS active_18, p0_.client_id AS client_id_19 FROM pdv p0_ WHERE p0_.id IN ('1', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '70', '71', '72');
|
2.35 ms (5.68%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.cpf AS cpf_4, t0.avatar AS avatar_5, t0.token AS token_6, t0.firebase_token AS firebase_token_7, t0.os AS os_8, t0.initial AS initial_9, t0.active AS active_10, t0.can_register AS can_register_11, t0.did_register AS did_register_12, t0.salt_pass AS salt_pass_13, t0.salt_pass_expires_at AS salt_pass_expires_at_14, t0.token_expire_at AS token_expire_at_15, t0.firebase_expire_at AS firebase_expire_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.last_login AS last_login_19, t0.roles AS roles_20, t0.password AS password_21 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.cpf AS cpf_4, t0.avatar AS avatar_5, t0.token AS token_6, t0.firebase_token AS firebase_token_7, t0.os AS os_8, t0.initial AS initial_9, t0.active AS active_10, t0.can_register AS can_register_11, t0.did_register AS did_register_12, t0.salt_pass AS salt_pass_13, t0.salt_pass_expires_at AS salt_pass_expires_at_14, t0.token_expire_at AS token_expire_at_15, t0.firebase_expire_at AS firebase_expire_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.last_login AS last_login_19, t0.roles AS roles_20, t0.password AS password_21 FROM user t0 WHERE t0.id = 1;
|
1.95 ms (4.72%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.retail AS retail_4, t0.distributor AS distributor_5, t0.cnpj AS cnpj_6, t0.static_map AS static_map_7, t0.address AS address_8, t0.number AS number_9, t0.zip_code AS zip_code_10, t0.neighborhood AS neighborhood_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.lat AS lat_15, t0.lng AS lng_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.active AS active_19, t0.client_id AS client_id_20 FROM pdv t0 INNER JOIN pdv_products ON t0.id = pdv_products.pdv_id WHERE pdv_products.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.retail AS retail_4, t0.distributor AS distributor_5, t0.cnpj AS cnpj_6, t0.static_map AS static_map_7, t0.address AS address_8, t0.number AS number_9, t0.zip_code AS zip_code_10, t0.neighborhood AS neighborhood_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.lat AS lat_15, t0.lng AS lng_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.active AS active_19, t0.client_id AS client_id_20 FROM pdv t0 INNER JOIN pdv_products ON t0.id = pdv_products.pdv_id WHERE pdv_products.product_id = 5;
|