SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520680 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520680 [ RunTime:0.003447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672101,180586,1020902,378050,124558,49024,1015434,681909,982484,580390,467008,823319,867542,44921,383102,220387,351079,167966,589124,94264,559099,792257,905103,483684,918457,33545,368685,322933,901312,596489,83531,755333,34677,976643,783538,431318,259352,178179,723202,535856,412295,899884,57462,911382,44006,964427,412364,936980,194770,237425,553481,176943,773553,709784,109790,557785,271193,378914,37476,565339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]