SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001851s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201708 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201708 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117907,37351,741981,340679,781030,384606,939320,327904,994883,631160,895560,1044874,38835,585333,689932,150799,331759,618462,960552,1036327,427646,36759,1329,433097,186686,109746,509823,737135,786312,763,558137,4581,902111,452977,112142,704950,34524,786437,264803,246902,590321,438013,461023,40578,292023,41199,174371,689433,1017902,1024576,186561,425704,59255,700691,995272,1023678,849430,996680,668577,754262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]