SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504471 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504471 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516699,987774,309425,734780,389043,174210,1035315,460818,902172,843834,717668,469632,842824,216459,206654,205065,508237,770631,549814,878723,752480,96424,820610,728419,940157,538957,331496,88186,193735,174139,585504,574056,245091,494726,253849,100399,248014,405489,973080,996622,333773,536150,183882,378626,757604,983998,177240,69448,573125,840901,699511,607558,318975,16837,530931,298706,442165,325565,125088,433626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]