SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501054 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501054 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141995,746517,441800,17305,135077,403476,454084,1009379,778881,282292,998549,105400,772225,505019,965573,325426,773667,166899,424782,839422,965851,644062,913466,216660,410851,269755,442291,593471,199656,431224,882929,862626,260429,665843,310320,1022108,166139,956264,430858,57958,300473,841669,718775,821202,625412,603480,703613,541930,495984,888695,861724,303852,545378,459560,304925,691251,411200,220736,827500,3218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]