SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002833s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 633518 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 633518 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608529,650747,677303,876379,546323,522715,311899,428151,115027,87950,791415,61887,24989,838370,29217,876616,754412,986563,948731,664656,461443,953794,132855,427130,766299,587654,156001,723763,212655,860441,549986,1047708,123824,122158,585036,447521,1048761,897262,397227,67674,884068,30460,455095,215914,632879,973094,333700,992485,911159,737015,410170,948259,624984,885849,378321,442597,66013,246010,813288,430130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 633518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 633518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]