SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491728 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491728 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451193,716552,495386,962345,450038,908682,393365,530462,838744,379301,342522,728149,513920,300634,532941,740000,97263,959871,284008,564721,702743,150827,515565,864717,298698,960475,630910,23285,150379,239499,511581,314062,558385,493540,41294,19256,378302,858849,1024245,117639,998313,806063,565697,737142,789798,253730,990269,367020,616845,173467,626298,3230,898543,835312,1,596549,803281,969851,449382,224027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]