SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240812 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240812 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21893,589171,1000257,637840,128159,413915,983402,775080,860598,806802,462616,730091,817387,983229,926186,132133,516884,349541,453420,707399,955472,1031011,298048,829926,709072,794164,199660,965294,809307,562633,756486,750405,899291,945550,596564,43461,476153,410468,153211,45395,1042631,984126,743108,968864,387583,956316,90074,500803,779924,989694,290780,139864,165554,125171,419458,498134,529424,133423,42497,714529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]