SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354710 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354710 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409481,110062,277591,925450,110948,50996,626395,687900,960581,245461,270612,465688,254561,690139,199374,423123,297380,92864,1025586,809465,129734,292619,207588,345882,789952,345908,579591,600310,427510,985336,179344,825455,158771,65425,619757,571711,355637,366032,968257,296751,965743,607747,330973,14034,123121,305155,187664,349808,451516,527828,272607,802517,344385,400411,362592,14005,346873,548215,152773,827586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]