SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552001 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552001 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034323,550391,1012203,1002023,324937,42181,803696,430568,683304,1015738,641824,503816,856051,147240,669882,1022380,389218,767468,209013,317884,242711,703992,129116,378555,878077,449193,980782,772670,73795,33217,462439,145125,868358,133144,93635,58927,930222,702382,1032087,502456,612751,864925,698186,800598,87153,384359,340206,383247,7032,431610,382771,62279,353028,909084,625660,612410,369621,677636,105785,594286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]