SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341310 LIMIT 1 [ RunTime:0.001499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341310 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942196,946705,74166,13571,877517,617351,1013404,283907,743684,59251,164713,92965,953542,282990,591297,244464,879268,436804,396974,596493,1042296,378650,1020509,770365,18252,295814,669609,1010745,356920,684626,216549,716643,918918,210322,407157,129405,190994,167037,362000,854528,279213,506285,719108,267686,586544,406859,741630,501807,711195,461920,912920,23270,613472,549201,87789,691749,507070,240908,1009992,705895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]