SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001915s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41226 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41226 [ RunTime:0.002810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240811,438839,618588,318876,231640,340103,758239,292314,906811,416177,647865,950656,376559,59903,338584,232971,585631,427385,341745,881267,808596,737844,299024,1025310,298258,229204,162389,424732,342172,772827,414745,410948,832113,397089,153858,791132,295192,240382,766009,56383,227345,896285,211304,854100,348350,326169,190476,30736,229860,652933,596505,281415,854066,657382,183224,900608,861430,28452,902151,1016089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001681s ]