SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142147 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142147 [ RunTime:0.001396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429855,1002166,654402,899500,507987,662507,892040,55376,81720,911680,270037,418005,193675,315046,1039483,467911,538186,986229,515495,672217,197192,577386,948154,777252,206215,922431,707179,886832,513004,806634,79759,302127,964356,350322,433793,639644,79391,438629,19090,503597,507639,327085,300202,570563,435470,500443,98773,148625,728779,202153,501547,944686,21170,988504,561074,579427,445473,123412,598598,824113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]