SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318712 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318712 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902400,1042049,813132,81433,1013806,552388,457546,214087,635333,831801,449642,391497,327675,664960,101894,603429,23426,727809,312037,911795,812479,914688,339289,805180,344490,249477,832873,19913,118285,121247,948737,349997,421439,517660,617873,470564,404355,460781,125467,979915,403165,147625,104039,1027237,303746,129300,260013,47062,627150,528948,980218,59612,661816,180364,91186,826415,269125,483822,911439,752335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000770s ]