SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349826 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349826 [ RunTime:0.003165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710454,58124,453949,952097,157596,94939,1000763,524379,933573,117588,264937,545467,643861,1014961,252107,53214,296581,692521,989574,474504,560797,158612,272315,770152,640956,959019,895419,900928,784392,240214,431722,51452,741539,482931,857275,87057,41303,331233,934752,882557,653586,602167,443324,365905,478850,625060,969652,132682,95644,460269,677718,470148,118968,275669,423152,543688,636527,819250,346336,999063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]