SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037412 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037412 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508086,98933,359327,486285,140118,748362,182816,345388,220964,676332,667401,758010,566523,346338,222616,633790,558882,648504,848465,367483,110978,951503,835937,82112,951883,262122,987037,797796,799791,367183,864563,255316,388646,749887,516337,867684,492139,660827,382343,328773,145195,598456,714362,679019,327910,91073,744036,277558,527025,552276,293669,696550,291550,511160,209492,579007,307534,228742,791113,472356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]