SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402961 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402961 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111123,71547,95429,867391,530293,535262,485456,1032505,812994,215290,943583,817640,640238,841656,796244,323542,576399,517987,342674,1003023,314436,491216,74817,369097,496527,213881,547191,524791,631821,719906,381401,577291,617309,797071,740936,936224,239064,972233,165333,849247,765099,165756,960726,269416,329800,1045930,184792,916552,461807,914564,108899,754281,214515,665614,360677,539291,1020951,23776,248820,993998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]