SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438931 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438931 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907283,265897,601746,881304,646973,153885,995318,228211,906788,385279,641836,22316,60318,334337,953917,671969,574575,815553,764683,577864,834610,111133,86311,17531,716262,1033946,169132,798273,118155,257573,637993,516801,653679,76654,262971,788949,568664,118933,334749,260134,599536,1012114,1038278,1010177,522032,630253,941060,339528,679563,825791,895481,648586,515883,168159,676572,239556,477381,1004339,43190,653261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]