Query time 0.00183
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "70.00"
},
"table": {
"table_name": "cscart_users",
"access_type": "ALL",
"rows_examined_per_scan": 650,
"rows_produced_per_join": 65,
"filtered": "10.00",
"cost_info": {
"read_cost": "63.50",
"eval_cost": "6.50",
"prefix_cost": "70.00",
"data_read_per_join": "701K"
},
"used_columns": [
"user_id",
"status",
"user_type",
"user_login",
"referer",
"is_root",
"company_id",
"last_login",
"last_activity",
"timestamp",
"password",
"salt",
"firstname",
"lastname",
"company",
"email",
"phone",
"fax",
"url",
"tax_exempt",
"lang_code",
"birthday",
"purchase_timestamp_from",
"purchase_timestamp_to",
"responsible_email",
"password_change_timestamp",
"api_key",
"helpdesk_user_id",
"external_id",
"access",
"first_banner",
"token",
"crm_id_user",
"inn",
"ogrn",
"dskey",
"referral_code",
"referral_id",
"ga",
"ym_uid",
"utm",
"file_place",
"isEmailConfirmed",
"isPhoneConfirmed",
"opf",
"check_status_time",
"company_status_id",
"not_resident",
"isIndividualPerson"
],
"attached_condition": "(`dev2`.`cscart_users`.`company_id` = 692)"
}
}
}
Result
user_id |
status |
user_type |
user_login |
referer |
is_root |
company_id |
last_login |
last_activity |
timestamp |
password |
salt |
firstname |
lastname |
company |
email |
phone |
fax |
url |
tax_exempt |
lang_code |
birthday |
purchase_timestamp_from |
purchase_timestamp_to |
responsible_email |
password_change_timestamp |
api_key |
helpdesk_user_id |
external_id |
access |
first_banner |
token |
crm_id_user |
inn |
ogrn |
dskey |
referral_code |
referral_id |
ga |
ym_uid |
utm |
file_place |
isEmailConfirmed |
isPhoneConfirmed |
opf |
check_status_time |
company_status_id |
not_resident |
isIndividualPerson |
881 |
A |
V |
user_881 |
|
Y |
692 |
0 |
1735012500 |
1733656922 |
$2y$10$/c20EWmtsdcx6VCwyolU4.D2a3PXhyOzP8ndKJzaLZwzFC55enQIS |
|
Даниил |
Касьянов |
ООО "АВИМАШ" |
user_881@test.finleo.ru |
79000000881 |
|
https://avimash.ru/ |
N |
ru |
0 |
0 |
0 |
|
1733656922 |
|
0 |
|
|
0 |
cd128cfefa993497cdc0cdd3167fa63b |
19720 |
7415112561 |
|
|
|
0 |
|
|
a:6:{s:6:"source";s:14:"default_source";s:6:"medium";s:6:"direct";s:8:"campaign";s:0:"";s:4:"term";s:0:"";s:8:"referrer";s:0:"";s:7:"content";s:0:"";} |
0 |
1 |
1 |
O |
0 |
1 |
N |
|