SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020070 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020070 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315246,239783,542481,541957,62095,32366,978905,751226,248621,276266,533543,320699,616042,1036152,542430,712561,215472,862561,807697,436873,584384,397522,110417,943888,931934,891870,193586,645917,447565,884897,607527,663923,360527,325929,343665,182174,820026,942135,1994,1022540,885673,989024,592705,1006799,739047,601419,171163,640917,567919,103904,765964,422919,905983,797701,987271,17508,436349,1010350,90253,725064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]