SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466035 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466035 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33127,316794,486619,983112,80828,12011,179545,837344,519458,994413,650746,773678,223061,795041,612972,147259,630899,523088,113620,452900,50734,828366,1032612,87739,8648,1008734,785097,380246,854502,369090,377811,752759,181860,138398,673437,607667,510032,239971,212472,250261,63494,702983,636424,758051,846691,582301,763125,392327,465234,59101,83614,528684,850310,974365,1041631,172928,300035,987159,120963,350321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]