SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489711 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489711 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324610,674711,523415,1004311,223311,776688,27638,134812,544192,618748,879319,771878,766482,44741,241318,523291,661946,335638,652301,254313,751157,182212,211033,471124,288624,60620,315659,503156,528554,766416,802850,162708,661809,906389,774971,553607,620095,232553,873684,555228,695422,964151,623808,837766,914368,971280,645297,461721,325276,1006060,845296,561769,511681,493419,530691,206013,672681,76417,931884,13594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]