SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264911 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264911 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620455,817867,234071,366964,508757,291614,1041655,980136,530648,154385,49376,321925,48557,6186,909265,439424,697881,635975,429485,1034090,953733,241791,657088,585361,479688,548962,62616,432978,441079,895505,890373,426238,756607,358220,583779,394803,58271,762404,756306,366613,1042288,922510,547048,322324,935095,1024475,386078,861348,100159,335734,246771,643748,834707,523048,132085,909156,945320,794367,741850,158869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]