SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505888 LIMIT 1 [ RunTime:0.001392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505888 [ RunTime:0.005332s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645021,194281,602477,710546,929113,484766,885452,1024317,982599,202441,445559,699426,947623,433356,321276,590764,963902,160137,585593,856890,421456,755308,732038,915110,370481,264039,758806,791114,931280,380990,982482,726345,556558,246517,336712,75424,702199,142472,824517,708936,757369,170516,690889,296978,414444,816129,648389,847450,920308,318771,624199,415133,127284,445573,903733,986089,888859,22790,852125,467923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003839s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]