SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 761999 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 761999 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973748,364972,686153,384580,744158,1023410,461647,233002,204978,857083,495597,30874,269408,502121,296834,608868,287370,494466,487359,621396,564125,640598,97509,383517,245351,234117,414933,142495,720439,696848,209190,335054,80410,729309,743710,985000,535549,711522,412289,434322,705024,550871,73260,756196,393213,345573,1013516,850659,1009684,691738,57999,877629,15309,862348,912488,570333,230708,1038882,1001818,608849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 761999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 761999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]