SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354110 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354110 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386618,235577,410523,800854,523886,323390,1038758,74818,405820,277373,1034762,804247,479882,42892,684487,900320,440096,95370,923516,894423,692426,95914,34450,688826,999701,765180,486130,62046,577972,544797,619966,784008,198731,74056,480362,473273,1041114,399436,690112,114481,618965,337751,751386,657297,232440,593706,22545,942637,950763,650280,407253,118138,164740,327854,35584,1047972,782337,1039968,95210,713966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]