SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415421 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415421 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161847,554865,841582,109973,57638,859458,307035,1008404,682224,351237,156336,726601,878077,586726,915169,711278,71996,226137,128782,944919,482019,442292,442226,968997,502027,41423,525088,116081,851808,54853,501359,616850,938332,986971,779171,596221,731798,571264,884035,329445,647677,445730,461955,20307,1001737,850634,418277,654463,407248,993002,552399,334,531897,58807,557359,696344,373458,241400,852862,4227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]