SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107201 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107201 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859369,920178,323840,227358,439001,343272,764916,272068,486250,871068,799810,301936,719664,351459,810895,536363,155058,539149,741746,554635,194407,818827,392601,481697,582993,454166,425037,656171,989466,65177,226606,219557,900927,500762,853078,295650,340239,722187,949923,94694,100726,387036,38017,348020,731361,317043,417309,165795,557125,93375,286461,1034360,646851,598240,146343,181114,782710,17875,1043970,885648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]