SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101746 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101746 [ RunTime:0.002424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574050,481401,410008,633639,666489,98490,839022,78323,196656,975485,110352,317789,161451,346229,135749,1025836,230435,585938,379479,683332,434848,125091,390296,110854,623074,121965,797543,506192,291233,883421,1001746,1006714,201331,852619,285147,1003846,822215,937635,855014,56716,979280,619098,702528,354324,455520,468986,778442,303539,848264,374081,961788,884428,701267,865176,1003103,918890,261403,656242,581928,97562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]