SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517575 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517575 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701481,871660,236993,393151,705304,417942,518844,466977,89301,802344,43343,803705,820068,325470,408501,473613,794302,526317,256318,355158,190779,525299,1045274,947867,21597,945917,42242,605149,356104,896998,121813,565000,384499,124797,226198,368399,686755,709499,412864,685071,876899,735124,309974,352378,82353,399722,655426,856548,542371,895743,465326,558491,339054,303281,76209,940008,6382,636846,631058,701706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]