SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280523 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280523 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729374,303887,519075,479022,69452,701778,422854,684538,191252,819897,371261,408478,49510,936611,470325,1033111,387438,133023,714191,765527,743658,711001,340328,931654,102050,716424,539977,417385,88010,98447,730270,460159,514925,361426,752741,824454,300684,305787,850769,372287,392766,93101,82418,233145,651500,787801,118261,429726,43750,361515,117966,724467,668848,599915,897913,816376,797179,322107,888306,331942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001191s ]