SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104514 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104514 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851279,306712,433719,304354,860498,1010054,832541,176806,632245,635579,263812,196219,988757,415640,63377,526085,385318,496155,15202,602991,1036328,191219,983000,625532,921026,229174,1034711,407700,265904,938528,638335,35175,873198,7163,95957,93651,429192,643197,171699,289925,638148,636570,504407,342403,970387,305238,559621,858940,568237,468989,11919,246781,637319,431607,519780,675622,247036,198493,309377,440224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]