SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415676 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415676 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320019,368971,849216,60503,883676,253323,735763,358718,651292,280705,797210,201906,322733,406961,728710,674925,995320,104388,924453,779848,220003,673267,344183,538890,47638,482937,1041266,460667,955817,323122,376535,601664,434538,62842,869985,23148,261595,306646,428539,381210,569640,183263,961935,831784,692811,994689,313986,406599,37183,18807,314664,797537,591106,148996,387938,560389,996910,655582,842282,104506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]