SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420203 LIMIT 1 [ RunTime:0.003926s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420203 [ RunTime:0.003745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269472,41497,63832,145340,629798,69136,687469,171754,955451,71164,442747,218113,405185,941530,857848,989911,690679,114410,952148,847824,885088,597330,69453,702162,1020029,923514,213149,705578,755648,957256,1032647,399398,630389,797288,263634,160987,458061,402839,1043247,767013,217835,534520,860828,522464,968660,990102,616276,647168,597735,321088,49597,536458,216764,370601,552308,669173,84333,717727,708006,574085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]