SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391016 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391016 [ RunTime:0.001447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535699,740251,761936,463435,259814,262471,600976,868282,653065,7976,967353,287519,1020352,755184,344625,319937,920779,102678,911986,406075,913452,1035049,989185,813796,1036529,116307,214665,195034,591221,278350,732217,403400,25925,530808,82704,122857,2985,55367,910343,574404,64288,990532,278544,705924,680034,905494,159619,975174,344708,242248,332428,96299,912094,520951,193005,217666,742709,897766,637196,468817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002444s ]