SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004575s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040346 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040346 [ RunTime:0.004695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379239,426076,439540,598669,529142,399929,873199,372741,516709,888140,429577,841732,699874,330890,146788,41501,282212,4290,573597,939064,79646,304106,979962,305918,580949,622640,650381,319901,308405,164830,901618,698215,516282,562728,453395,484558,30881,385353,820809,280662,222012,902699,227676,890358,775351,961658,411057,938124,859618,749902,843098,1033340,933303,503199,455934,399332,229250,510609,338601,676450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]