SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391480 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391480 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481032,407662,972622,354279,848844,937555,121683,807167,1017711,317824,409034,1002019,18410,397366,254807,726389,505528,381668,215936,711519,797474,214673,598798,381113,408496,30615,136458,508789,616414,876316,474368,876441,622881,235108,80070,797656,226107,133921,917035,243762,1018865,1046105,111365,585429,920279,411700,806319,991823,298098,188507,845091,152501,302454,63618,921907,44403,200442,581515,84286,223075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000373s ]