SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287448 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287448 [ RunTime:0.004842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029304,655331,552751,790101,140984,139806,199207,412392,1005839,30834,534385,550982,146110,539722,607473,933583,1027672,536162,348861,796264,872351,768735,943951,96537,759427,626703,972376,220008,481640,908014,725218,837957,970720,141288,342308,274179,613501,799678,971381,1013240,299849,63195,212774,915268,615337,710994,439731,115076,533433,1003484,413236,507194,958954,639945,809726,467786,604133,87226,827525,280727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001380s ]