SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40453 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40453 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911721,542974,583513,584872,586351,681460,196652,55448,327392,616046,326205,281097,110974,940160,44080,41723,418256,627087,321960,992918,358090,165728,475793,358574,649351,1000083,46551,91839,117247,425133,735780,463171,577540,713346,596004,586697,934059,138625,183193,316725,840322,35279,350537,860930,488648,646405,860852,1040009,224765,895148,14686,186888,444267,29393,558883,549246,703015,744236,116823,687724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]