SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129883 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129883 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402440,535008,852654,175045,212685,595480,93443,680195,521612,395553,413439,720863,632206,449634,908673,920019,443710,571083,400242,348928,896293,1024271,976515,554752,968575,195627,1043312,772176,21027,572158,995567,122391,541801,826714,998475,993234,523383,345701,405722,876945,89286,496681,105198,563427,1027123,701073,459357,561453,544292,698030,219557,940024,170,241022,3364,953089,395710,368793,820745,528644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001589s ]