SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401197 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401197 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037042,495889,631536,547265,763800,692545,460360,997481,861702,714011,933567,368678,880788,140442,426995,548170,191922,150653,1022956,332681,414100,74199,137675,955323,704342,788,184482,973946,962286,84588,676579,109241,142548,48399,882616,390368,478489,282147,808148,801248,565027,665199,719472,441665,1359,101501,270326,63760,514153,840539,397307,334939,525711,3467,984967,557173,299001,763832,705028,638994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]