SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320650 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320650 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660245,652320,422045,647180,855718,990796,24834,629146,419694,905110,356867,1015002,639000,967211,168558,889726,1008998,545560,111516,1005303,1009939,868818,836330,615217,132056,353085,629410,973655,327565,952757,269420,613779,937252,917592,636286,206225,1000740,734900,789455,660491,919616,551688,698295,166070,765405,908187,969860,219390,992157,819679,331107,340519,652563,714873,515374,164309,1001890,624726,439793,168834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]