SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434510 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434510 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873576,688057,514382,747497,324082,349047,808288,928457,407180,670645,424277,438358,754015,251363,774980,833515,445516,509939,293046,538005,613816,679002,4495,986732,850937,473909,946411,307579,135543,991172,586855,357414,697820,817529,12068,123799,931044,228190,707752,66797,256577,158295,252037,36897,70725,523512,488289,889357,70490,117404,295225,1839,384997,334717,885074,886490,513247,214374,690041,391066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]