SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418060 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418060 [ RunTime:0.001422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494954,616790,600833,657220,262422,26924,61482,123800,557284,129035,948472,146917,407559,14095,424725,344578,498701,876577,53529,589665,623682,544365,581659,175665,612452,94017,961619,635066,701265,744588,947777,840167,314846,314702,239926,868825,396626,990071,465991,546111,769225,377431,585267,30418,960348,403471,832908,932836,998967,994769,334492,425743,406507,233972,994566,561744,323551,917014,996310,729216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]