SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401966 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401966 [ RunTime:0.002324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508474,420039,454967,455655,240457,152122,198822,8998,1030183,118807,227732,515848,609934,744963,781232,546511,930232,372866,74202,752548,652201,921761,593379,69707,143491,214009,369864,632829,566303,263889,956499,230643,251188,831111,795722,207799,533500,487928,868003,888003,358258,268594,414046,816336,307234,345809,817287,165954,367404,736371,525637,922260,389739,999507,565843,594635,799350,138900,380983,186495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001336s ]