SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541029 LIMIT 1 [ RunTime:0.000799s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541029 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751182,972915,392780,790012,25391,505451,183278,157651,110686,100112,640662,815073,859829,485170,461269,791441,894992,407278,260084,698086,610912,947420,197495,561327,588225,490658,91600,263208,59409,126094,925081,151735,170717,641423,371065,244158,253625,200083,886200,880707,626401,1003559,172983,55823,371649,41289,875338,638378,892910,739185,550133,394111,808584,677803,508469,247712,381841,88155,219410,358027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002254s ]