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` = 1026474 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026474 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636252,362079,293624,833017,997462,106604,995268,825449,460927,791909,583955,206540,823943,492293,171041,465468,151912,711152,969100,179157,556961,920421,916140,602000,64698,378629,908445,825684,649267,357616,56210,742590,212985,1008802,858509,919858,777510,548996,560906,976726,455632,926131,182870,573383,178508,406971,475483,895180,557800,494576,462993,345511,875171,822122,296544,983083,120113,389636,84899,508819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]