SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502205 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502205 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72345,22760,579310,61276,395120,242003,449736,238528,934606,453264,489911,11157,733787,137937,559895,731237,168135,144508,659787,577630,1012943,518223,433581,674821,54212,46026,1041442,506120,176462,410560,92095,742207,719832,791559,677893,231242,512717,871077,482113,501230,76159,890529,997248,28228,208756,395693,468088,93925,531258,957301,385077,412217,565370,496113,293701,244305,728228,39087,483871,489668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]