SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840936 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840936 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704491,248359,332301,1000424,699179,706757,454488,39873,700894,748370,268990,365539,1036586,48609,468566,114160,157889,865187,33505,287475,808625,443212,338107,463922,147279,749463,1031866,248344,63700,1015759,630345,419106,428044,840281,66167,236633,1013200,48631,573030,27420,1028128,952670,282592,141805,624541,413829,193348,937977,985382,844758,11393,388512,872854,551439,517024,506990,160907,478107,150624,997573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]