SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010 [ RunTime:0.003063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412775,886448,345742,769273,1023544,1045697,425954,481124,694848,452087,113330,166755,815536,52980,865138,985537,176938,608295,742648,819857,426510,702085,931638,138479,924156,38442,1008341,39577,897337,332837,667651,799354,969735,66756,977609,753767,1009700,823882,269306,733892,270826,64945,913483,693075,510287,805411,609697,720000,79429,953817,132214,539123,456843,720899,1047918,699966,75128,113647,451368,608397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]