SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401688 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401688 [ RunTime:0.003866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221695,490259,544404,939750,947044,361098,427535,452542,268320,326645,396920,551505,170716,1017221,819160,632627,459184,155475,830852,522420,357507,669848,145163,466305,253598,829168,316271,645240,150731,768567,733592,758194,246008,489562,699766,177890,146443,108669,996366,988988,196276,666529,938016,1000134,572286,676171,442705,267058,95205,1032582,639400,322514,1046252,202965,77565,844980,503405,634577,878390,653536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000910s ]