SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 158401 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 158401 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454349,104654,142108,537647,405370,1009744,1011806,201410,127942,661299,540999,859310,705878,755547,309132,351740,441987,464965,132073,225641,67061,642332,171200,233171,995053,1001089,351823,7794,213494,327574,564755,460595,539180,667733,108739,943719,277111,441986,32533,1042222,61171,494887,991786,890813,490336,187627,550308,982215,970235,527522,356708,568152,895740,639522,889969,548155,724360,26901,115034,141393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 158401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 158401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000937s ]