SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164083 LIMIT 1 [ RunTime:0.001707s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164083 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587839,730160,965813,433249,1033600,557629,449594,99709,682172,834955,477911,803150,1048490,442441,252541,426241,708854,513256,188392,676714,302112,121785,1033010,31081,882070,831920,119409,443190,1026385,199021,494071,931193,710632,449971,765282,112142,528384,222020,754656,234438,105767,302676,879418,433646,665374,726901,38708,841038,926454,773752,582816,287316,915503,149139,442437,154120,460866,996309,664882,1048331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]