SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499040 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499040 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154033,937517,674941,556630,470071,384205,643773,749383,638209,1020248,392573,111581,748541,486469,355527,286752,68726,157186,381874,26721,1042406,357214,273463,995284,1039332,78325,749940,839465,621068,990249,766965,261929,384489,151866,435011,780549,844268,1035256,531963,660379,355416,508504,435290,339591,689718,642807,109659,353677,931741,643554,195051,240548,463875,916122,912346,480530,479306,193439,666059,622184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]