SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 772005 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 772005 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608048,674278,67859,375138,916309,231351,887496,1414,33435,77927,721661,112052,455576,111984,75276,395140,178151,562369,618127,445899,236155,85080,284656,188388,616625,780042,791364,22535,270255,980692,268916,915104,680985,710115,180643,83475,834228,554664,654902,766714,602704,148167,52689,920450,1042012,172487,930743,492580,540851,522694,337004,715289,715900,391366,195877,41523,822446,361648,215648,134296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 772005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 772005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]