SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464581 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464581 [ RunTime:0.002916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414918,1041261,864298,426131,636814,227543,637406,891900,299176,152386,611427,22582,320668,842438,48581,831097,901158,677005,887303,427852,319834,309093,568685,974502,38635,417510,781542,295958,760167,480083,959635,901467,710743,730979,604691,820353,254448,950603,522627,428426,108880,976049,653125,305299,1019496,725551,149514,974551,417678,723404,816070,655416,424436,383276,688700,775458,112738,791888,979705,456992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]