SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398522 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398522 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313814,70214,209940,417600,329612,672609,261736,40511,387812,194191,387761,562850,38905,18424,770250,933333,16362,607963,697630,943590,132597,234802,933370,527767,519039,910529,403256,758205,547245,613649,97088,748230,609368,468686,578045,813751,420304,497897,746162,276194,235819,816385,555166,859789,727743,691193,48087,434517,952042,543990,250146,88767,106712,143007,506858,680225,79612,319411,499926,858247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]