SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353834 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353834 [ RunTime:0.003484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249369,208660,963529,45754,378524,404994,208842,477822,205186,798840,525686,147564,490631,911460,270218,103874,502615,1010858,533106,475850,184789,873600,433285,487020,974267,506615,167009,768148,526954,678261,922288,292129,250566,469606,452106,345032,442177,558806,222176,817982,877687,320499,1019031,489938,452631,694600,505485,866474,12122,422962,478048,775615,177018,902193,637355,213343,367227,151088,662177,728562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]