SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503713 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503713 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369333,893261,966987,85238,153838,568861,200287,403796,19339,829581,173864,45469,118572,233599,7983,914306,281171,231103,27657,74148,22969,93165,448076,990018,889315,803348,440265,93695,161177,763281,1047457,373887,597948,364928,142494,707375,306175,458085,60244,506908,869225,984787,242625,627532,544087,212684,605137,4341,998824,407088,800548,845233,203066,837981,282731,184585,963841,328052,17775,233873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]