SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455283 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455283 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128113,74653,1044595,129293,1006136,929133,742094,867184,746908,244968,314474,561050,1048311,531566,160447,873030,174034,515723,458396,181197,578094,859829,77166,992317,573040,460625,642910,313964,226758,536413,73405,327093,354332,725291,172238,129387,418431,376127,879462,656008,202663,772340,676341,261760,870153,146521,40618,132987,944302,1036416,110947,927321,361544,680608,68650,197632,119902,342663,763473,416395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]