SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478014 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478014 [ RunTime:0.002454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384919,719890,591437,216629,1008263,15594,120248,681986,464834,112891,442275,184493,479787,990148,727162,676406,353308,411140,137181,992582,952777,481473,334541,538481,60552,831829,247168,304449,616840,589132,795195,938731,260890,795174,741590,485256,365165,367032,89028,710458,124820,695657,886523,900921,1010157,230479,943406,749122,740273,291156,980404,365823,94083,56479,335607,972249,522347,717616,885054,714016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]