SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198018 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198018 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41061,1024513,308312,942065,892904,662911,506988,30589,871469,981090,104643,54535,367877,418706,922766,643990,82590,424036,105649,529826,847605,803327,236834,621980,649504,250091,298525,130824,729350,377303,526734,323205,939571,867450,159320,151931,901055,293305,317145,1000350,712890,776023,184953,1022042,921461,484840,970327,279171,172225,376266,672344,844751,500555,236740,300297,547160,766947,726222,66516,411110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]