SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575104 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575104 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726393,1001252,493574,1040636,733449,732733,352915,706421,676426,403827,454014,1032698,227211,514957,673056,52262,513721,355450,999302,497905,24030,453355,676977,841992,780742,527166,58221,916001,343135,647445,919007,301927,733824,140731,1046628,152744,1018184,487564,309911,99942,401727,868237,211782,674485,851508,303375,795648,112890,483097,197093,360957,366027,1042116,375056,398254,1010100,718195,948299,454231,736982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]