Unlimited access to statistics and facts
Unlimited access to statistics and facts
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Language`.`nomenclatura`, `Language`.`id` FROM `saas_statlat`.`languages` AS `Language` WHERE `state` = 1 | 2 | 2 | 0 | |
| 2 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id`, `Session`.`ip`, `Session`.`state` FROM `saas_statlat`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'gj2qhdcc5i8fdqetdfi9l1ksh0' LIMIT 1 | 0 | 0 | 0 | |
| 3 | SELECT `Language`.`id`, `Language`.`name`, `Language`.`nomenclatura`, `Language`.`state`, `Language`.`created`, `Language`.`modified` FROM `saas_statlat`.`languages` AS `Language` WHERE `Language`.`nomenclatura` = 'eng' LIMIT 1 | 1 | 1 | 0 | |
| 4 | SELECT `Language`.`id`, `Language`.`name`, `Language`.`nomenclatura`, `Language`.`state`, `Language`.`created`, `Language`.`modified` FROM `saas_statlat`.`languages` AS `Language` WHERE `Language`.`state` = 1 | 2 | 2 | 0 | |
| 5 | SELECT `Nation`.`id`, `Nation`.`name` FROM `saas_statlat`.`nations` AS `Nation` WHERE 1 = 1 ORDER BY FIELD( name, 'Colombia' ) DESC , name ASC | 236 | 236 | 2 | |
| 6 | SELECT `Transaction`.`id`, `Transaction`.`user_id`, `Transaction`.`currency`, `Transaction`.`value`, `Transaction`.`payment`, `Transaction`.`reference_id`, `Transaction`.`id_generate`, `Transaction`.`state`, `Transaction`.`is_trial`, `Transaction`.`is_free`, `Transaction`.`created`, `Transaction`.`modified`, `Transaction`.`upgrade`, `Transaction`.`plan_id`, `Transaction`.`notify`, `Transaction`.`type_transaction`, `Transaction`.`number_users` FROM `saas_statlat`.`transactions` AS `Transaction` WHERE ((`Transaction`.`state` = 'PENDING') OR (`Transaction`.`state` = 'INPROCESS')) AND `Transaction`.`user_id` IS NULL AND `Transaction`.`notify` = 1 LIMIT 1 | 0 | 0 | 1 | |
| 7 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`company`, `User`.`image`, `User`.`created`, `User`.`modified`, `User`.`state`, `User`.`hash_change_password`, `User`.`identification`, `User`.`white_label`, `User`.`role`, `User`.`logo`, `User`.`type_user`, `User`.`phone`, `User`.`ext`, `User`.`lang`, `User`.`address`, `User`.`position`, `User`.`user_id`, `User`.`platform`, `User`.`username`, `User`.`city_id`, `User`.`is_customer`, `User`.`terminos`, `User`.`datos`, `User`.`accepting_data_collection` FROM `saas_statlat`.`users` AS `User` WHERE `User`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| 8 | SELECT `Suscription`.`id`, `Suscription`.`plan_id`, `Suscription`.`payment_id`, `Suscription`.`date_ini`, `Suscription`.`date_end`, `Suscription`.`state`, `Suscription`.`created`, `Suscription`.`modified`, `Suscription`.`value_user`, `Suscription`.`user_id`, `Suscription`.`active`, `Plan`.`id`, `Plan`.`name`, `Plan`.`name_eng`, `Plan`.`description`, `Plan`.`description_eng`, `Plan`.`estadisticas`, `Plan`.`descarga_excel`, `Plan`.`descarga_pdf`, `Plan`.`descarga_png`, `Plan`.`descargas`, `Plan`.`variables`, `Plan`.`carpeta_marcadores`, `Plan`.`derecho_de_publicacion`, `Plan`.`informes_sectoriales`, `Plan`.`expedientes`, `Plan`.`estudio_anual_personalizado`, `Plan`.`soporte_email`, `Plan`.`soporte_telefonico`, `Plan`.`soporte_chat`, `Plan`.`users`, `Plan`.`price_user`, `Plan`.`price`, `Plan`.`price_discount`, `Plan`.`state`, `Plan`.`modified`, `Plan`.`created`, `Payment`.`id`, `Payment`.`value`, `Payment`.`state`, `Payment`.`date`, `Payment`.`created`, `Payment`.`modified`, `Payment`.`data_result`, `Payment`.`transaction_id`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`company`, `User`.`image`, `User`.`created`, `User`.`modified`, `User`.`state`, `User`.`hash_change_password`, `User`.`identification`, `User`.`white_label`, `User`.`role`, `User`.`logo`, `User`.`type_user`, `User`.`phone`, `User`.`ext`, `User`.`lang`, `User`.`address`, `User`.`position`, `User`.`user_id`, `User`.`platform`, `User`.`username`, `User`.`city_id`, `User`.`is_customer`, `User`.`terminos`, `User`.`datos`, `User`.`accepting_data_collection` FROM `saas_statlat`.`suscriptions` AS `Suscription` LEFT JOIN `saas_statlat`.`plans` AS `Plan` ON (`Suscription`.`plan_id` = `Plan`.`id`) LEFT JOIN `saas_statlat`.`payments` AS `Payment` ON (`Suscription`.`payment_id` = `Payment`.`id`) LEFT JOIN `saas_statlat`.`users` AS `User` ON (`Suscription`.`user_id` = `User`.`id`) WHERE `Suscription`.`user_id` IS NULL AND `Suscription`.`active` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 9 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`image`, `Advertisement`.`url`, `Advertisement`.`text`, `Advertisement`.`state`, `Advertisement`.`priority`, `Advertisement`.`client`, `Advertisement`.`created`, `Advertisement`.`modified` FROM `saas_statlat`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`state` = 1 | 1 | 1 | 0 |