SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517827 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517827 [ RunTime:0.002187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281222,715766,724499,934996,25005,753908,92786,868927,1011890,1036949,765699,996962,786568,178080,137273,202088,527221,539370,416745,159528,417025,589691,126864,178379,1010036,367808,632111,616873,872897,183,570632,844347,724748,129307,626246,443929,815589,802581,301360,461884,367373,681983,185458,947616,461083,665816,396922,719768,973035,923243,649298,493503,586264,310319,630400,808348,942770,697258,920535,997489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]