SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804328 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804328 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433399,295667,44792,802090,32983,750588,1018009,752696,620415,339519,529702,1023439,1019676,247708,95510,541981,1021309,612725,850899,412397,455856,293260,1047419,1027597,729760,832741,425000,771613,386032,573571,421142,640632,751238,465986,762791,977953,531476,348237,876641,737435,524831,513604,388583,807868,898742,109464,516921,593338,855530,377914,55967,437089,464077,766039,957645,92617,123702,538883,816385,764191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]