SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008020 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008020 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987677,1019440,1030723,228371,243073,405529,180651,174981,44271,971626,612831,623687,150018,198740,777007,874004,353690,677552,991569,760604,258334,296340,1042148,572886,58009,412701,327357,80737,25615,564459,120969,409390,508737,309235,220790,299395,423911,315876,177809,194579,363779,867899,882010,144342,602468,865001,655987,729963,673777,842173,377564,119281,130391,473486,713253,148445,336380,774472,734008,327678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]