SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499048 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499048 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010042,813280,719008,805601,88315,396861,451914,718065,822740,633998,960077,495946,421614,774971,618249,394716,986354,720034,55559,73604,299404,265272,118846,523164,709136,427523,951346,532981,809432,604809,51580,521036,947222,367339,330865,234169,14887,844890,153294,36029,565864,873126,1000608,596584,853300,130862,560479,489402,367084,89566,898769,793330,453405,768720,254690,579954,965581,352372,722270,527561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]