SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449451 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449451 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163576,925931,769603,852355,901256,163599,663433,681936,735311,1020481,393666,853852,117733,295221,709084,987753,77644,195232,61181,993998,1004900,986817,781715,10041,88653,213342,171863,441469,877788,925077,181508,329485,670206,656366,144624,546034,849917,406940,583633,981361,290932,531042,140831,683104,204636,252978,20267,646396,834305,243011,775112,781823,71361,626050,159438,351293,169695,946754,450450,971553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001591s ]