SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522215 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522215 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265941,870342,439067,482382,809158,676028,724362,497523,456177,143390,782157,775925,93290,993980,336930,387666,884243,378329,123098,387591,721950,117667,431209,402216,745926,704604,311530,173583,222302,193891,271507,280393,862661,769054,906335,128040,251183,1015198,1000229,695667,719265,21696,798917,720902,1010599,1041778,892906,655819,559090,347504,1011421,96800,485407,297495,459383,763095,317946,906312,605445,864941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]