SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506401 LIMIT 1 [ RunTime:0.000665s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506401 [ RunTime:0.002424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836479,97306,504069,279530,183182,15057,1040375,711055,166383,336568,520056,503295,572385,89209,637452,892029,502302,373208,990127,212151,1003951,728322,524643,499957,123639,671199,352372,217834,692658,195281,925984,431151,307028,660092,700068,217764,1013875,848848,697229,952675,450558,356812,95810,844877,875933,667425,166748,68314,846279,616967,122486,51176,868000,696301,160160,792384,722406,160075,14877,831298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]