SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112301 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112301 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401352,2896,854257,106187,486427,812161,81415,76006,574067,51618,667029,236187,246295,1023590,235880,476720,856730,105262,418402,587604,737969,591775,1045805,453785,839169,418880,41380,993103,341577,622344,505663,681200,312686,56857,625777,838520,138384,326230,553304,166981,521238,207225,504227,273067,95013,771738,1016323,892234,555140,177021,941064,32456,232770,200817,461703,549372,716980,14577,485729,836811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]