SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544373 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544373 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410241,201385,584224,527915,61984,450369,650326,171843,894326,401867,975760,655071,884846,275845,202737,867324,202002,166990,19495,1038247,845888,948044,423206,545027,977869,334013,348080,155420,1026742,429009,953628,784559,736027,366833,416836,863075,500136,958774,627319,816638,433472,393710,561474,975228,29421,557087,508343,83340,765224,53674,81280,593520,173813,610857,540698,163706,214948,997953,832353,967073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001104s ]