SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406614 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406614 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267863,340223,229276,319929,401677,891179,485039,192203,841187,92696,612334,285690,137970,411377,556077,557693,21157,280130,214828,575854,628587,81184,502486,312205,997010,992067,86230,1019974,445450,238398,395198,736631,695887,334875,884118,608493,424501,90638,647569,619610,604891,783453,136504,104487,883325,140452,70767,337346,245346,250208,115043,801015,490079,875230,478098,635411,236040,93706,747494,246202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]