SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327067 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327067 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107907,746850,644378,800158,110807,637673,774028,448954,45158,100573,919855,1040826,332660,750874,896918,516670,313072,28299,520476,537212,361033,674429,412614,683892,161907,948501,671683,70119,52140,145030,302230,995866,777237,827422,444595,112845,575415,247820,653306,119466,484514,1005281,542791,268005,621269,808228,936091,861263,333929,1014013,559393,843599,576172,1048526,192424,143464,714843,451350,756740,736073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]