SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013750 LIMIT 1 [ RunTime:0.001926s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013750 [ RunTime:0.004520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430993,204604,270339,585777,512312,737820,86078,500529,720091,642848,746232,69565,739404,907534,932230,236663,436464,409493,283094,618722,55414,819014,84907,180002,29478,1023516,745860,740139,505481,734212,255686,659675,128624,135684,73447,226750,78669,298310,404109,485729,11127,790480,222937,151190,562376,874346,205878,688829,246653,125787,135755,437508,441416,62287,496198,632346,97499,432352,612343,217031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]