SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111796 LIMIT 1 [ RunTime:0.000791s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111796 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028983,142187,221313,600927,862755,75126,407438,261855,645389,872399,315761,119888,959586,205830,1045034,493635,951214,305990,707665,202821,936409,80870,528331,1023540,589895,398602,470967,72942,274756,716805,743177,44605,989463,247850,552219,1045185,669203,125375,1003125,519741,532923,432904,675466,810156,971117,967480,783084,22863,856205,1014430,27939,418261,626644,763277,274761,661090,774472,560763,161732,541911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]