SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030022 LIMIT 1 [ RunTime:0.001281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030022 [ RunTime:0.003552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368602,566287,41011,446867,237170,374437,164892,297194,311897,987577,264031,162116,603462,289365,455105,688414,760911,394220,562661,710938,893435,232870,994067,880679,143177,14199,376358,670711,991974,670241,745172,202888,705251,738590,333174,336142,1002229,249721,723387,13323,690664,523827,274067,234551,887137,459280,327937,765575,23583,505767,578795,1046424,749502,430925,654224,621239,704847,277569,328304,8246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002271s ]