SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201032 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201032 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712434,787247,737011,798923,625832,603306,112356,586138,916116,281781,752412,147132,73842,890295,336874,149393,944583,924246,915669,942280,678616,430644,447382,574324,853784,666607,864266,49394,158777,428214,485634,386875,226537,257817,421659,249980,846141,672132,598336,1013731,620790,160748,437102,613719,352735,247156,944414,277026,308526,324184,82998,953856,703155,148931,828595,678740,341421,561156,850393,30130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]