SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400040 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400040 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444391,481918,3734,373198,401920,337994,259491,659854,483276,147227,964876,647484,499664,60102,542758,151202,818089,171862,428713,913618,439184,728981,227322,142158,908975,720150,891965,146570,511889,288737,891485,468465,410870,936385,282846,514321,535906,293714,977286,1029580,98909,951276,930153,193862,323362,572940,293301,499357,426872,907443,773627,881157,269871,211081,885550,642855,538085,667456,800278,776530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]